SELECT SUBSTRING(user_email,POSITION('@' IN user_email) + 1) AS emai
You'll probably have to write your own external function to do that.
The MS_STUFF example might help:
http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/External-Functions.html#External-Functions
On Wed, Nov 4, 2009 at 7:45 PM, Roman Sokolyuk <romsok.tech@gmail.com> wrote:
> Hi,
>
> If I have a column that contains email addresses, is there a way for me to
> select just the domain from SQL, so for dave@gmail.com, bob@yahoo.com, I
> will get just "gmail.com", and "yahoo.com"?
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
>
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users