numbers and strings 1

[stevenfilip]

Hi All,

For example if I have an integer number of : 107
but i would like to put it in the database as : 0107

And if I have a string : AAB
But I would like to put it in the database as : 0AAB

How would I do something like that?

Thanks!

Steven
(newbie)

 

[webmigit]

Well the number would be handled like this...

<CFSET myNumber=#NumberFormat(myNumField,&quot;0000&quot> ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.