While testing the sql code presented in this thread, I observed that if I change the decimal point '.' literal in the code to a comma ',', the above sql runs to completion without error. When the comma ' ,' is replaced with a decimal '.' point, the sql gives the error described below.

Why is that? Please help me with the reasonaleit the solution. Here is the example when the comma literal is used and the sql completes successfully: Please observe that now there is a comma inserted between WGT and numbers. The decimal position will always remain 0.00 much like currency designation.

Thanks

TEXT (column)

------------------------

KEY1742888,WGT,99,QTY1

KEY1742888,WGT3,46,QTY1

KEY1742888,WGT3,44,QTY1

KEY1742888,WGT4,24,QTY1

KEY1742888,WGT,66,QTY1

KEY1742888,WGT1,00,QTY1

KEY1742888,WGT1,00,QTY1

KEY1742888,WGT1,00,QTY1

KEY1742888,WGT,81,QTY1

KEY1742888,WG,T1,QTY2

KEY1742888,WGT,94,QTY1

KEY1742889,WG,T3,QTY1

KEY1742889,WGT1,10,QTY1

KEY1742889,WGT1,04,QTY1

KEY1742889,WGT1,01,QTY1

KEY1742889,WGT2,29,QTY1

KEY1742889,WGT2,32,QTY1

KEY1742889,WGT2,28,QTY1

KEY1742889,WGT,80,QTY1

KEY1742889,WGT,70,QTY1

KEY1742889,WGT3,50,QTY1

KEY1742889,WGT2,80,QTY1

KEY1742889,WGT2,90,QTY1

KEY1742889,WGT1,96,QTY1

KEY1742889,WGT3,28,QTY1

KEY1742889,WGT2,35,QTY1

KEY1742889,WGT2,71,QTY1

KEY1742889,WGT,39,QTY1

KEY1742889,WGT,98,QTY1

KEY1742889,WGT1,41,QTY1

KEY1742889,WG,T2,QTY1

KEY1742889,WGT2,06,QTY1

KEY1742889,WG,T2,QTY1

KEY1742889,WGT,64,QTY1

KEY1742889,WGT1,66,QTY1

KEY1742889,WGT1,53,QTY1

KEY1742889,WGT1,48,QTY1

KEY1742889,WGT1,32,QTY1

KEY1742889,WGT1,33,QTY1

KEY1742889,WGT1,69,QTY1

KEY1742889,WGT1,01,QTY1

KEY1742889,WGT1,79,QTY1

KEY1742889,WGT,57,QTY1

KEY1742889,WG,T6,QTY1

KEY1742889,WGT1,72,QTY1

KEY1742889,WGT2,59,QTY1

KEY1742889,WGT1,58,QTY1

KEY1742889,WGT1,17,QTY1

KEY1742889,WGT1,54,QTY1

KEY1742889,WG,T4,QTY1

KEY1742889,WG,T1,QTY1

KEY1742889,WGT1,30,QTY1

KEY1742889,WGT1,63,QTY1

KEY1742889,WGT,88,QTY1

KEY1742889,WGT3,16,QTY1

KEY1742889,WGT1,64,QTY1

KEY1742889,WGT1,00,QTY1

KEY1742889,WGT1,00,QTY1

KEY1742889,WGT,87,QTY1

KEY1742889,WGT,87,QTY1

KEY1742889,WGT2,30,QTY1

KEY1742889,WGT1,14,QTY1

KEY1742889,WG,T1,QTY2

KEY1742889,WGT1,00,QTY1