trimming characters

[parames]

hi all..
how to get the numbers from a string..

for example let say my value is
"252mm"
i just want to store 252 in my database and take out the "mm"..
how to do this..
please help..

thanks a lot..

regards,
parames.s

 

[culshaja]

You would use the [bold]CInt[/bold] function. This will drop the characters.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[culshaja]

You would use the CInt function. This will drop the characters.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305