Consider the email address as a @-delimited list and get the first and last
member of the list.
best, paul
At 01:28 PM 2/28/01 -0600, you wrote:
>I am trying to separate an e-mail address from the domain - everything to
>the right of the "@" symbol. I have 2 database fields named [Email] and
>[Domain] and I am trying to use either a MID or TRIM statement to copy just
>the domain information into the [Domain] Field.
>
>Any suggestions would be greatly appreciated!!!
>
>Troy Wussow
>Web Developer - MIS
>National Seminars Group
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists