SELECT substring(email, charindex('@', email)+1, 255) as Domain FROM usersShould get you there. On Fri, May 29, 2009 at 3:47 PM, Barney Boisvert <[email protected]>wrote: > > check the reverse, locate, and left functions. reverse it, find the > delimiter, and then use left to strip off the prefix. > > cheers, > barneyb > > On Fri, May 29, 2009 at 12:44 PM, Paul Ihrig <[email protected]> wrote: > > > > how can i do > > ListLast(your_email,"@") > > > > in a sql statement > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
