trim(listLast(field)) & " " & trim(listFirst(field))
At 12:47 PM 4/12/2001, you wrote:
>Hi,
>I have a field with Smith, John as the contents.
>
>I want to display John Smith...
>
>I'm think I get the total length(a), then the charlength of the comma(b).
>
>Take contents b + 1 and subtract that from a equals (c)
>Then display the difference of c to a (d)
>and then output c after d to the total of the field....
>
>Any other ideas?
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
