suresh64633 Posted August 25, 2009 Share Posted August 25, 2009 How can i sort alphanumeric values? I have values in my table with varchar data type as: 119 11 32 06104 16010-SM4-A30 17801-0W010 F80H19N619AA JE48-13-Z40 I want to sort it as first all alphabets with spaces and dash(-) than alphanumeric and than Aphabets. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 28, 2009 Share Posted August 28, 2009 Show the desired order... also, are these the only examples of possible content? Quote Link to comment Share on other sites More sharing options...
suresh64633 Posted August 31, 2009 Author Share Posted August 31, 2009 My values may be: SM4 A31 123 123456789 123-SM4-A31 123-456-791 123 456 790 123-SM4-932 SM4-932-123 123.456.792 And i want it to be sorted like this: 123456789 123 456 790 123-456-791 123.456.792 123-SM4-932 123-SM4-A31 SM4-932-123 SM4 A31 123 It should sort first numbers [irrespective of Sapces( ) dashes(-) and point(.)] and than aplhanumeric numbers. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 7, 2009 Share Posted September 7, 2009 Are they always groups of three? Quote Link to comment Share on other sites More sharing options...
suresh64633 Posted September 8, 2009 Author Share Posted September 8, 2009 No not compulsory. But they are at least 6 character[alphanumeric] long. Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted September 8, 2009 Share Posted September 8, 2009 For what you have described, the following query works (tested) - $query = "SELECT your_column, REPLACE(REPLACE(REPLACE(your_column,'.',''),'-',''),' ','') as test FROM your_table ORDER BY test"; Quote Link to comment Share on other sites More sharing options...
suresh64633 Posted September 8, 2009 Author Share Posted September 8, 2009 Thank you for your valuable reply. I used that query but does not serve the purpose. SELECT RefNum, REPLACE( REPLACE( REPLACE( RefNum, '.', '' ) , '-', '' ) , ' ', '' ) AS sortedRefNum FROM otherrefs ORDER BY sortedRefNum LIMIT 500 , 1000 Full Texts OEMNum sortedRefNum 15208-AD20A 15208AD20A 15208-AD300 15208AD300 15208-BN31A 15208BN31A 15231-43560 1523143560 15231-43563 1523143563 15278634 15278634 15278637 15278637 15287103 15287103 15400-PL2-003 15400PL2003 15400-PL2-004 15400PL2004 15400-PL2-005 15400PL2005 15400-PL2-015 15400PL2015 15400-PL2-305 15400PL2305 15410-52D00 1541052D00 15410-52D20 1541052D20 15410-60B00 1541060B00 15410-60B01 1541060B01 15410-60G00 1541060G00 15410-61A00 1541061A00 15410-62G00 1541062G00 15410-63401 1541063401 15410-63B01 1541063B01 15410-65D00 1541065D00 15410-65D10 1541065D10 15410-67B01 1541067B01 15410-72F00 1541072F00 15410-72F01 1541072F01 15410-79100 1541079100 15410-80000 1541080000 15410-80C00 1541080C00 15410-80C10 1541080C10 15410-80C30 1541080C30 15410-82000 1541082000 15410-82400 1541082400 15410-84380 1541084380 15410-85200 1541085200 15410-85Z00 1541085Z00 15410-86501 1541086501 15410-86510 1541086510 15410-86Z00 1541086Z00 15410A78B00-000 15410A78B00000 15410-KF0-000 15410KF0000 15410-KF0-315 15410KF0315 15411-78E10 1541178E10 15430-50G00 1543050G00 15430-PLZ-D00 15430PLZD00 15521-43160 1552143160 1 562 374 1562374 1567.03 156703 1567.05 156705 1567.07 156707 1567.10 156710 1567.11 156711 1567.12 156712 1567.13 156713 1567.81 156781 1567.85 156785 1567.87 156787 1567.93 156793 15800986 15800986 15811562 15811562 15875795 15875795 15893542 15893542 15925738 15925738 15942429 15942429 16010-S84-G01 16010S84G01 16010-SB2-680 16010SB2680 16010-SD4-670 16010SD4670 16010-SD4-Z01 16010SD4Z01 16010-SE0-631 16010SE0631 16010-SE0-632 16010SE0632 16010-SH3-931 16010SH3931 16010-SH3-C30 16010SH3C30 16010-SK3-E31 16010SK3E31 16010-SK3-E32 16010SK3E32 16010-SK7-A60 16010SK7A60 16010-SK7-A61 16010SK7A61 16010-SK7-A62 16010SK7A62 16010-SM4-931 16010SM4931 16010-SM4-932 16010SM4932 16010-SM4-951 16010SM4951 16010-SM4-952 16010SM4952 16010-SM4-A30 16010SM4A30 16010-SM4-A31 16010SM4A31 16010-SO1-A01 16010SO1A01 16010-SO1-A31 16010SO1A31 16010-SO1-A32 16010SO1A32 16010-SP0-931 16010SP0931 16010-SPO-931 16010SPO931 16010-SS0-930 16010SS0930 16010-SS0-931 16010SS0931 16010-SS1-930 16010SS1930 16010-ST5-931 16010ST5931 16010-ST5-932 16010ST5932 16010-ST5-933 16010ST5933 160 180 0310 1601800310 160 184 0025 1601840025 160 184 0225 1601840225 1612 6 750 475 16126750475 1612 6 754 016 16126754016 OEMNum sortedRefNum 1614 6 757 196 16146757196 16235-PA6-003 16235PA6003 16235-PC1-003 16235PC1003 16235-PC1-013 16235PC1013 16235-PC6-003 16235PC6003 16235-PC6-013 16235PC6013 16235-PE0-003 16235PE0003 16235-PH1-003 16235PH1003 16235-PH1-013 16235PH1013 16271-43560 1627143560 16271-45360 1627145360 163 830 0047 1638300047 163 835 0047 1638350047 163 835 0247 1638350247 16400-03J00 1640003J00 16400-06W00 1640006W00 16400-08W00 1640008W00 16400-0B000 164000B000 16400-0M200 164000M200 16400-0W000 164000W000 16400-0W005 164000W005 16400-10Y00 1640010Y00 16400-18010 1640018010 16400-3S500 164003S500 16400-41B00 1640041B00 16400-41B01 1640041B01 16400-41B02 1640041B02 16400-41B05 1640041B05 16400-53J10 1640053J10 16400-59A00 1640059A00 16400-61A00 1640061A00 16400-68201 1640068201 16400-70J00 1640070J00 16400-70J10 1640070J10 16400-72L00 1640072L00 16400-72L01 1640072L01 16400-72L02 1640072L02 16400-72L03 1640072L03 16400-72L04 1640072L04 16400-72L05 1640072L05 16400-72L15 1640072L15 16400-76201 1640076201 16400-7B000 164007B000 16400-7B010 164007B010 16400-9E000 164009E000 16400-A0600 16400A0600 16400-A4201 16400A4201 16400-C6400 16400C6400 16400-C6401 16400C6401 16400-D0100 16400D0100 16400-D0300 16400D0300 16400-E3000 16400E3000 16400-E3001 16400E3001 16400-E3022 16400E3022 16400-E3025 16400E3025 16400-E5200 16400E5200 16400-E5201 16400E5201 16400-E6600 16400E6600 16400-EC00A 16400EC00A 16400-ES60A 16400ES60A 16400-F5100 16400F5100 16400-F5700 16400F5700 16400-H8500 16400H8500 16400-H8501 16400H8501 16400-H8502 16400H8502 16400-H8594 16400H8594 16400-J7525 16400J7525 16400-JD50A 16400JD50A 16400-N1400 16400N1400 16400-N1410 16400N1410 16400-N4200 16400N4200 16400-N4201 16400N4201 16400-N7600 16400N7600 16400-N7601 16400N7601 16400-N7602 16400N7602 16400-N7603 16400N7603 16400-N7604 16400N7604 16400-N7605 16400N7605 16400-N8400 16400N8400 16400-N8600 16400N8600 16400-N8601 16400N8601 16400-N9600 16400N9600 16400-N9601 16400N9601 16400-N9694 16400N9694 16400-Q0500 16400Q0500 16400-Q0800 16400Q0800 16400-R0101 16400R0101 16400-S9A00 16400S9A00 16400-V2600 16400V2600 16400-V2600 16400V2600 16400-V2700 16400V2700 16400-W1100 16400W1100 16400-W7060 16400W7060 16400-W7061 16400W7061 16403-34W00 1640334W00 16403-59E00 1640359E00 16403-7F401 164037F401 16403-G2400 16403G2400 16403-G9900 16403G9900 16405-01T70 1640501T70 OEMNum sortedRefNum 16405-02N10 1640502N10 16405-05E01 1640505E01 16405-10G03 1640510G03 16405-T9001 16405T9001 16405-T9002 16405T9002 16405-V0701 16405V0701 16419-N3411 16419N3411 16510-61A20MHL 1651061A20MHL 16510-61A30 1651061A30 16510-79J50 1651079J50 16546-02N00 1654602N00 16546-06N00 1654606N00 16546-0B000 165460B000 16546-0U800 165460U800 16546-0Z000 165460Z000 16546-15M00 1654615M00 16546-15M10 1654615M10 16546-18000 1654618000 16546-1P100 165461P100 16546-30P00 1654630P00 16546-41B00 1654641B00 16546-60U00 1654660U00 16546-64J02 1654664J02 16546-65J00 1654665J00 16546-73C10 1654673C10 16546-74S00 1654674S00 16546-76000 1654676000 16546-76015 1654676015 16546-77A10 1654677A10 16546-7F002 165467F002 16546-7S000 165467S000 16546-84A10 1654684A10 16546-86G00 1654686G00 16546-88A00 1654688A00 16546-89W00 1654689W00 16546-AA010 16546AA010 16546-AA020 16546AA020 16546-AA030 16546AA030 16546-AA070 16546AA070 16546-AA07A 16546AA07A 16546-AA080 16546AA080 16546-AA090 16546AA090 16546-AA10A 16546AA10A 16546-AA12A 16546AA12A 16546-AR000 16546AR000 16546-AW300 16546AW300 16546-D1100 16546D1100 16546-EA000 16546EA000 16546-ED000 16546ED000 16546-EG000 16546EG000 16546-EH000 16546EH000 16546-ET000 16546ET000 16546-F5101 16546F5101 16546-JA00A 16546JA00A 16546-JA00B 16546JA00B 16546-JK20A 16546JK20A 16546-KA120 16546KA120 16546-M5600 16546M5600 16546-N4200 16546N4200 16546-R9000 16546R9000 16546-T3400 16546T3400 16546-U6710 16546U6710 16546-V0100 16546V0100 16546-V0110 16546V0110 168 830 0018 1688300018 168 830 0818 1688300818 16900-538-003 16900538003 16900-538-004 16900538004 16900-538-013 16900538013 16900-538-014 16900538014 16900-538-023 16900538023 16900-538-024 16900538024 16900-611-004 16900611004 16900-611-014 16900611014 16900-634-000 16900634000 16900-634-004 16900634004 16900-658-004 16900658004 16900-671-003 16900671003 16900-671-004 16900671004 16900-671-013 16900671013 16900-671-014 16900671014 16900-671-023 16900671023 16900-671-024 16900671024 16900-671-033 16900671033 16900-671-034 16900671034 16900-S84-G01 16900S84G01 16900-SA0-003 16900SA0003 16900-SA0-004 16900SA0004 16900-SA0-014 16900SA0014 16900-SA0-023 16900SA0023 16900-SA0-024 16900SA0024 16900-SA0-033 16900SA0033 16900-SA0-044 16900SA0044 16900-SA0-901 16900SA0901 16900-SA0-902 16900SA0902 16900-SA0-903 16900SA0903 16900-SA0-904 16900SA0904 16900-SA5-000 16900SA5000 16900-SA5-003 16900SA5003 16900-SA5-004 16900SA5004 OEMNum sortedRefNum 16900-SA5-013 16900SA5013 16900-SA5-023 16900SA5023 16900-SB2-681 16900SB2681 16900-SB2-682 16900SB2682 16900-SB2-684 16900SB2684 16900-SB2-685 16900SB2685 16900-SB2-731 16900SB2731 16900-SB2-733 16900SB2733 16900-SB2-734 16900SB2734 16900-SD4-670 16900SD4670 16900-SD4-671 16900SD4671 16900-SD4-672 16900SD4672 16900-SD4-A50 16900SD4A50 16900-SD4-A51 16900SD4A51 16900-SD7-670 16900SD7670 16900-SD7-671 16900SD7671 16900-SD7-690 16900SD7690 16900-SD7-930 16900SD7930 16900-SD7-931 16900SD7931 16900-SE0-000 16900SE0000 16900-SE0-003 16900SE0003 16900-SE0-004 16900SE0004 16900-SE0-931 16900SE0931 16900-SE0-932 16900SE0932 16900-SE0-A31 16900SE0A31 16900-SF0-670 16900SF0670 16900-SF0-671 16900SF0671 16900-SF0-931 16900SF0931 16900-SF0-G32 16900SF0G32 16900-SF1-003 16900SF1003 16900-SF1-A32 16900SF1A32 16900-SF1-A33 16900SF1A33 16900-SF1-E01 16900SF1E01 16900-SF1-E02 16900SF1E02 16900-SH3-930 16900SH3930 16900-SH3-931 16900SH3931 16900-SH3-932 16900SH3932 16900-SH3-A30 16900SH3A30 16900-SH3-A31 16900SH3A31 16900-SK3-E31 16900SK3E31 16900-SK7-930 16900SK7930 16900-SK7-A30 16900SK7A30 16900-SK7-A31 16900SK7A31 16900-SK7-A60 16900SK7A60 16900-SK7-A61 16900SK7A61 16900-SK7-A62 16900SK7A62 16900-SK7-Q30 16900SK7Q30 16900-SK7-Q61 16900SK7Q61 16900-SL0-931 16900SL0931 16900-SL0-A30 16900SL0A30 16900-SL0-A31 16900SL0A31 16900-SL5-A31 16900SL5A31 16900-SM3-A32 16900SM3A32 16900-SM4-A31 16900SM4A31 16900-SM4-A32 16900SM4A32 16900-SM4-A33 16900SM4A33 16900-SS0-931 16900SS0931 16901-RMA-E00 16901RMAE00 16901-S6F-E01 16901S6FE01 170013418 170013418 170014406 170014406 17067151 17067151 1718042 1718042 1718044 1718044 1718045 1718045 17220-689-000 17220689000 17220-689-003 17220689003 17220-P0A-A00 17220P0AA00 17220-P0G-A00 17220P0GA00 17220-P13-000 17220P13000 17220-P2A-005 17220P2A005 17220-P2F-A01 17220P2FA01 17220-P2J-003 17220P2J003 17220-P2M-Y00 17220P2MY00 17220-P2N-A01 17220P2NA01 17220-P2P-A00 17220P2PA00 17220-P5A-000 17220P5A000 17220-P72-000 17220P72000 17220-P8C-A00 17220P8CA00 17220-P8F-A00 17220P8FA00 17220-P8F-A10 17220P8FA10 17220-PAA-A00 17220PAAA00 17220-PCX-003 17220PCX003 17220-PDA-E01 17220PDAE01 17220-PE2-010 17220PE2010 17220-PE2-305 17220PE2305 17220-PGE-A00 17220PGEA00 17220-PGK-A00 17220PGKA00 17220-PH3-000 17220PH3000 17220-PH3-305 17220PH3305 17220-PH4-661 17220PH4661 17220-PH7-013 17220PH7013 17220-PH7-661 17220PH7661 17220-PHM-000 17220PHM000 17220-PJ0-600 17220PJ0600 17220-PK2-661 17220PK2661 17220-PLC-000 17220PLC000 17220-PLD-000 17220PLD000 17220-PLZ-E01 17220PLZE01 17220-PM2-305 17220PM2305 OEMNum sortedRefNum 17220-PM2-B01 17220PM2B01 17220-PM4-003 17220PM4003 17220-PM4-063 17220PM4063 17220-PM7-000 17220PM7000 17220-PM7-F00 17220PM7F00 17220-PMR-A00 17220PMRA00 17220-PNA-003 17220PNA003 17220-PNB-000 17220PNB000 17220-PNB-003 17220PNB003 17220-PO7-000 17220PO7000 17220-PP4-E00 17220PP4E00 17220-PR3-000 17220PR3000 17220-PR7-A00 17220PR7A00 17220-PT0-003 17220PT0003 17220-PT2-000 17220PT2000 17220-PT2-305 17220PT2305 17220-PV1-000 17220PV1000 17220-PWA-J10 17220PWAJ10 17220-PWC-000 17220PWC000 17220-PY2-000 17220PY2000 17220-PY3-000 17220PY3000 17220-PZA-000 17220PZA000 17220-PZD-A01 17220PZDA01 17220-PZX-003 17220PZX003 17220-R40-A00 17220R40A00 17220-R70-A00 17220R70A00 17220-RAA-A00 17220RAAA00 17220-RAA-A01 17220RAAA01 17220-RB0-000 17220RB0000 17220-RBB-A00 17220RBBA00 17220-RBB-A00 17220RBBA00 17220-RCA-A00 17220RCAA00 17220-RCJ-A00 17220RCJA00 17220-RDA-A00 17220RDAA00 17220-RDA-A10 17220RDAA10 17220-RDJ-J00 17220RDJJ00 17220-RGL-A00 17220RGLA00 17220-RGL-A10 17220RGLA10 17220-RJE-A00 17220RJEA00 17220-RK2-A00 17220RK2A00 17220-RL5-A00 17220RL5A00 17220-RMA-A00 17220RMAA00 17220-RMX-000 17220RMX000 17220-RN0-A00 17220RN0A00 17220-RNA-A00 17220RNAA00 17220-RRA-A00 17220RRAA00 17220-RUE-A00 17220RUEA00 17220-RWC-A00 17220RWCA00 17220-RYE-A00 17220RYEA00 17220-RZA-000 17220RZA000 17220-RZA-A00 17220RZAA00 17220-RZP-Y00 17220RZPY00 1770A012 1770A012 17801-01020 1780101020 17801-02030 1780102030 17801-02060 1780102060 17801-02070 1780102070 17801-02080 1780102080 17801-03010 1780103010 17801-03030 1780103030 17801-07010 1780107010 17801-07020 1780107020 17801-08010 1780108010 17801-0C040 178010C040 17801-0D020 178010D020 17801-0H010 178010H010 17801-0H020 178010H020 17801-0H050 178010H050 17801-0P010 178010P010 17801-0R010 178010R010 17801-0T030 178010T030 17801-0W010 178010W010 17801-10030 1780110030 17801-11030 1780111030 17801-11050 1780111050 17801-11080 1780111080 17801-11090 1780111090 17801-11110 1780111110 17801-13050 1780113050 17801-13070 1780113070 17801-14010 1780114010 17801-15010 1780115010 17801-15060 1780115060 17801-15070 1780115070 17801-16010 1780116010 17801-16020 1780116020 17801-16040 1780116040 17801-17020 1780117020 17801-20040 1780120040 17801-20050 1780120050 17801-21020 1780121020 17801-21030 1780121030 17801-21040 1780121040 17801-21050 1780121050 17801-22010 1780122010 17801-22020 1780122020 17801-23030 1780123030 17801-25010 1780125010 17801-27020 1780127020 17801-28010 1780128010 OEMNum sortedRefNum 17801-28030 1780128030 17801-31050 1780131050 17801-31090 1780131090 17801-31110 1780131110 17801-33040 1780133040 17801-35020 1780135020 17801-38010 1780138010 17801-38020 1780138020 17801-38030 1780138030 17801-41050 1780141050 17801-41090 1780141090 17801-41110 1780141110 17801-46060 1780146060 17801-46070 1780146070 17801-46080 1780146080 17801-48011 1780148011 17801-50010 1780150010 17801-50020 1780150020 17801-50030 1780150030 17801-50040 1780150040 17801-50060 1780150060 17801-54030 1780154030 17801-54040 1780154040 17801-54050 1780154050 17801-54060 1780154060 17801-54070 1780154070 17801-54080 1780154080 17801-54100 1780154100 17801-54140 1780154140 17801-54150 1780154150 17801-54170 1780154170 17801-61030 1780161030 17801-62010 1780162010 17801-63010 1780163010 17801-64010 1780164010 17801-64040 1780164040 17801-64080 1780164080 17801-66030 1780166030 17801-67030 1780167030 17801-67040 1780167040 17801-67060 1780167060 17801-68020 1780168020 17801-68030 1780168030 17801-70010 1780170010 17801-70020 1780170020 17801-70050 1780170050 17801-74010 1780174010 17801-74020 1780174020 17801-74060 1780174060 17801-87104-000 1780187104000 17801-87401-000 1780187401000 17801-87402-000 1780187402000 17801-87601-000 1780187601000 17801-87717 1780187717 17801-87717-000 1780187717000 17801-97201-000 1780197201000 17801-AD010 17801AD010 1784782 1784782 1808602 1808602 1808602 1808602 1808602 1808602 1808604 1808604 1808605 1808605 1808617 1808617 1808618 1808618 1808619 1808619 1808624 1808624 1808624 1808624 1858554 1858554 1858555 1858555 18808610 18808610 18808610 18808610 1902138 1902138 1902142 1902142 1906.29 190629 1906.33 190633 1906.34 190634 1906.35 190635 1906.38 190638 1906.39 190639 1906.42 190642 1906.43 190643 1906.48 190648 1906.49 190649 1906.50 190650 1906.51 190651 1906.51 190651 1906.76 190676 1906.96 190696 1908233 1908233 1908547 1908547 1909957 1909957 191-127-177B 191127177B 191-127-401 191127401 191-127-401A 191127401A 191-127-401B 191127401B 191-127-401C 191127401C 191-127-401E 191127401E 191-129-620 191129620 19184673 19184673 OEMNum sortedRefNum 1930010 1930010 194199A1 194199A1 194199A1 194199A1 1945199 1945199 1945199 1945199 195 195 50056 19519550056 195 195 50081 19519550081 1C0-127-401 1C0127401 1C3Z9601AA 1C3Z9601AA 1E00-61-J6X 1E0061J6X 1E07-13-480 1E0713480 1F1Z9155AD 1F1Z9155AD 1F1Z9155CA 1F1Z9155CA 1F20-13-470 1F2013470 1F70-13-470 1F7013470 1F70-13-470A 1F7013470A 1F70-23-603 1F7023603 1H0-091-800 1H0091800 1H0-127-401C 1H0127401C 1H0-127-401E 1H0127401E 1H0-127-401G 1H0127401G 1H0-129-620 1H0129620 1H0-201-511 1H0201511 1H0-201-511A 1H0201511A 1H0-819-644 1H0819644 1J0-127-401 1J0127401 1J0-129-620 1J0129620 1J0-129-620A 1J0129620A 1J0-201-511A 1J0201511A 1J0-819-644 1J0819644 1K0-127-177A 1K0127177A 1K0-127-177B 1K0127177B 1K0-127-434 1K0127434 1K0-127-434A 1K0127434A 1K0-127-434B 1K0127434B 1K0-129-620B 1K0129620B 1K0-129-620C 1K0129620C 1K0-129-620D 1K0129620D 1K0-129-620E 1K0129620E 1K0-201-051C 1K0201051C 1K0-819-644 1K0819644 1K1-819-653 1K1819653 1K1-819-653A 1K1819653A 1L0-129-620 1L0129620 1L0-129-620A 1L0129620A 1L0-129-620C 1L0129620C 1L2Z9155BA 1L2Z9155BA 1L2Z9601AA 1L2Z9601AA 1R4J18N405AD 1R4J18N405AD 1S71-9155AC 1S719155AC 1S7F16N619AC 1S7F16N619AC 1S7H19G244AC 1S7H19G244AC 1X439155AA 1X439155AA 1X43-9601AA 1X439601AA 2020064 2020064 202 830 00 18 2028300018 202 830 0018 2028300018 203 830 0118 2038300118 203 830 0218 2038300218 20386080 20386080 20435801 20435801 20704-A1100 20704A1100 2084467 2084467 2084528 2084528 21000932 21000932 21000938 21000938 21007146 21007146 21007147 21007147 21007148 21007148 21007149 21007149 21007437 21007437 21007438 21007438 21007449 21007449 21008019 21008019 21008344 21008344 21009412 21009412 21009413 21009413 21009427 21009427 21018801 21018801 21018826 21018826 210 830 06 18 2108300618 210 830 1018 2108301018 211 830 0018 2118300018 2120064 2120064 2121779 2121779 21999324 21999324 2202783 2202783 2240546 2240546 22612464 22612464 22633313 22633313 22633314 22633314 226 6556 2266556 22665802 22665802 22676970 22676970 22679620 22679620 22685727 22685727 22731072 22731072 22734980 22734980 23030-31031 2303031031 23030-50010 2303050010 OEMNum sortedRefNum 23030-62010 2303062010 23030-74020 2303074020 23030-74040 2303074040 23030-79025 2303079025 23030-79025 2303079025 23300-01010 2330001010 23300-09020 2330009020 23300-11050 2330011050 23300-11091B 2330011091B 23300-11100 2330011100 23300-11150 2330011150 23300-11190 2330011190 23300-13020 2330013020 23300-15010 2330015010 23300-15010 2330015010 23300-15020 2330015020 23300-16050 2330016050 23300-16060 2330016060 23300-16080A 2330016080A 23300-16140 2330016140 23300-16210 2330016210 23300-16220 2330016220 23300-16240 2330016240 23300-16270 2330016270 23300-16330 2330016330 23300-19045 2330019045 23300-19065 2330019065 23300-19085 2330019085 23300-19105 2330019105 23300-19115 2330019115 23300-19145 2330019145 23300-19165 2330019165 23300-19175 2330019175 23300-19195 2330019195 23300-19205 2330019205 23300-19225 2330019225 23300-19235 2330019235 2330019245 2330019245 23300-19245 2330019245 23300-19265 2330019265 23300-19285 2330019285 23300-19295 2330019295 23300-19325 2330019325 23300-19375 2330019375 23300-19385 2330019385 23300-19425 2330019425 23300-19435 2330019435 23300-19465 2330019465 23300-19475 2330019475 23300-20020 2330020020 23300-20040 2330020040 23300-20061 2330020061 23300-20070 2330020070 23300-20090 2330020090 23300-20100 2330020100 23300-20101 2330020101 23300-22020 2330022020 23300-22040 2330022040 23300-22050 2330022050 23300-24010 2330024010 23300-24020 2330024020 23300-24020C 2330024020C 23300-24050 2330024050 23300-24050 2330024050 23300-25020 2330025020 23300-25020 2330025020 23300-25050 2330025050 23300-25060 2330025060 23300-26060 2330026060 23300-26060 2330026060 23300-28010 2330028010 23300-28030 2330028030 23300-29045 2330029045 23300-29065 2330029065 23300-31090 2330031090 23300-31100 2330031100 23300-34100 2330034100 23300-34100 2330034100 23300-34100C 2330034100C 23300-35020 2330035020 23300-35030 2330035030 23300-36020 2330036020 23300-39025 2330039025 23300-39035 2330039035 23300-39045 2330039045 23300-39055 2330039055 23300-41030 2330041030 23300-41031 2330041031 23300-41050 2330041050 23300-42010 2330042010 23300-43020 2330043020 23300-43040 2330043040 23300-43060 2330043060 23300-45050 2330045050 23300-45051 2330045051 23300-45060 2330045060 23300-46060 2330046060 23300-46080 2330046080 23300-49025 2330049025 23300-49035 2330049035 OEMNum sortedRefNum 23300-49045 2330049045 23300-49055 2330049055 23300-49060 2330049060 23300-49065 2330049065 23300-49075 2330049075 23300-49115 2330049115 23300-49125 2330049125 23300-49145 2330049145 23300-49155 2330049155 23300-49185 2330049185 23300-49195 2330049195 23300-50020 2330050020 23300-50040 2330050040 23300-50050 2330050050 23300-50060 2330050060 23300-50090 2330050090 23300-61050 2330061050 23300-61060 2330061060 23300-61080 2330061080 23300-62010 2330062010 23300-62020 2330062020 23300-62030 2330062030 23300-65010 2330065010 23300-66010 2330066010 23300-66020 2330066020 23300-66050 2330066050 23300-69025 2330069025 23300-69035 2330069035 23300-69045 2330069045 23300-73010 2330073010 23300-74020 2330074020 23300-74040 2330074040 23300-74050 2330074050 23300-74080 2330074080 23300-74150 2330074150 23300-74210 2330074210 23300-74230 2330074230 23300-74260 2330074260 23300-74310 2330074310 23300-74340 2330074340 23300-75030 2330075030 23300-75031 2330075031 23300-75090 2330075090 23300-75100 2330075100 23300-75110 2330075110 23300-75140 2330075140 23300-76070 2330076070 23300-76080 2330076080 23300-79025 2330079025 23300-79055 2330079055 23300-79095 2330079095 23300-79105 2330079105 23300-79165 2330079165 23300-79175 2330079175 23300-79185 2330079185 23300-79235 2330079235 23300-79255 2330079255 23300-79275 2330079275 23300-79285 2330079285 23300-79295 2330079295 23300-79305 2330079305 23300-79335 2330079335 23300-79405 2330079405 23300-79425 2330079425 23300-79445 2330079445 23300-79446 2330079446 23300-79455 2330079455 23300-79495 2330079495 23300-79545 2330079545 23300-79555 2330079555 23300-87102-000 2330087102000 23300-87105-000 2330087105000 23300-87109-000 2330087109000 23300-87214-000 2330087214000 23300-87219-000 2330087219000 23300-87403-000 2330087403000 23300-87507-000 2330087507000 23300-87512-000 2330087512000 23300-87614-000 2330087614000 23300-87625-000 2330087625000 23300-87680-000 2330087680000 23300-87702-000 2330087702000 23300-87719-000 2330087719000 23300-87724-000 2330087724000 23300-87724-000 2330087724000 23300-87729-000 2330087729000 23300-87731-000 2330087731000 23300-87733-000 2330087733000 23300-87739-000 2330087739000 23300-YA010 23300YA010 23300-YA010 23300YA010 23303-56040 2330356040 23303-64010 2330364010 23303-64020 2330364020 23303-87308-000 2330387308000 23303-87309-000 2330387309000 23390-0L010 233900L010 23390-26140 2339026140 23390-64450 2339064450 23390-64480 2339064480 OEMNum sortedRefNum 234464-5 2344645 235116 235116 2373789 2373789 2406441 2406441 2408303 2408303 243214-4 2432144 243464-5 2434645 24415388 24415388 24460713 24460713 24508572 24508572 2463551 2463551 2463552 2463552 2465703 2465703 2467368 2467368 2495698 2495698 25012305 25012305 25012306 25012306 25022174 25022174 25040881 25040881 25040929 25040929 25042001 25042001 25042562 25042562 25043119 25043119 25043246 25043246 25043317 25043317 25043334 25043334 25043504 25043504 25050385 25050385 25055001 25055001 25055002 25055002 25055003 25055003 25055032 25055032 25055046 25055046 25055048 25055048 25055052 25055052 25055065 25055065 25055066 25055066 25055072 25055072 25055073 25055073 25055074 25055074 25055083 25055083 25055094 25055094 25055096 25055096 25055101 25055101 25055107 25055107 25055115 25055115 25055117 25055117 25055119 25055119 25055121 25055121 25055128 25055128 25055129 25055129 25055129 25055129 25055157 25055157 25055182 25055182 25055184 25055184 25055186 25055186 25055188 25055188 25055198 25055198 25055200 25055200 25055202 25055202 25055223 25055223 25055243 25055243 25055280 25055280 25055302 25055302 25055339 25055339 25055341 25055341 25055364 25055364 25055372 25055372 25055419 25055419 25055421 25055421 25055423 25055423 25055424 25055424 25055425 25055425 25055427 25055427 25055428 25055428 25055429 25055429 25055479 25055479 25055480 25055480 25055481 25055481 25055495 25055495 25055533 25055533 25055660 25055660 25055673 25055673 25055675 25055675 25055773 25055773 25055774 25055774 25055776 25055776 25055777 25055777 25055826 25055826 25055828 25055828 25055838 25055838 25055840 25055840 25055842 25055842 25055844 25055844 25055845 25055845 25055846 25055846 25055848 25055848 25055856 25055856 25055858 25055858 25055860 25055860 I tried to CAST the field 'test' as SIGNED (integer) but still not not working. Thanks Quote Link to comment Share on other sites More sharing options...
fenway Posted September 10, 2009 Share Posted September 10, 2009 What's wrong with it now Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.