SELECT substring(email, charindex('@', email)+1, 255) as Domain FROM users
Should get you there.
On Fri, May 29, 2009 at 3:47 PM, Barney Boisvert wrote:
>
> check the reverse, locate, and left functions. reverse it, find the
> delimiter, and then use left to strip off the prefix.
>
> cheers
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 wrote:
>
> how can i do
> ListLast(your_email,"@")
>
> in a sql statement
>
>
~~~
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-ta
3 matches
Mail list logo
