I'm querying this field from a table. How can I only get the last 18 numbers:
The numbers look like this:
If it is always the last 18 numbers just use the Right() function. Examples:
<cfset mystring = "500000000818118">
<cfset mynewstring = Right(mystring, 18)>
Well I just noticed that your example string is only 15 characters long. Perhaps I mis-understood your question?
Message was edited by: Miguel-F