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