remove commas from user inputted number 1

[MikeT]

A number that a user inputs is put into an SQL statement to update a database. However, if the user uses commas (e.g. 34,592), the syntax of the SQL statement becomes incorrect.
How do I remove the commas? Something like:
for x = 1 to len(number)
<code>
next
Am I on the right track?

 

[link9]

You can use the replace funtion...

For instance, if you have a variable, myVar with the commas in it and you want to remove them altogether, just say:

replace(myVar, ",", "")

good luck!
Paul Prewett

 

[MikeT]

Turns out if I put single quotes around the variable representing the number, the syntax remains intact.

NNNNEEEEEEEEEEEEEEEEEAAAAAAAAATTTTTTTTTOOOOOOOOOOOOO!!!!!!!!

 

[MikeT]

Wow link9, thats a sweet idea!
I'll remember that for future reference.
Thank you for posting!

MikeT

 

[Swany]

Just for your information, the ' may work in SQL server but it doesn't work for Oracle. If you try to insert a string literal into a number column you will get a &quot;Invalid Number&quot; error message.

With oracle you must use the replace(string,&quot;,&quot;,&quot;&quot