insert() function?
I have a number field, 1236547852145632, that I want to display like:
1236-5478-5214-5632
and don't want to do this...
<cfset myNum = 4103346331>
<cfloop from = 4 to = #len(myNum)# index = i step = 5>
<cfset myNum = insert('-',myNum,i)>
</cfloop>
too many times in a 10000 query recordset :)
if I can pass it off to sql server, GREAT!
thanks.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
visit www.antiwrap.com to send long url emails to your friends!
-- dont mistake my perfection as arrogance
anonymous
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]