See page 1023 of SYBEX's "Mastering Cold Fusion" book for list of SQL functions and
the databases they work with:
Concatenate the following functions into a SQL statement with an AS statement and it
should work...
mLEN = Length(trim(str1)) -- returns the length of the trimed str1 which you can store
in
mAT = Instr(str1, str2) ---- returns the numerical position in str1 where str2 begins.
mKEEP = Right(TRIM(str1), mLEN - mAT)
^
/ \__
( @\___
/ O
/ (_____/
/_____/
Whoof...
410-757-3487
-----Original Message-----
From: Troy M. Wussow [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 2:28 PM
To: CF-Talk
Subject: OT: HELP PLEASE! MS Access Trim Statement
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
