Actually, I found a way to do it in SQL - here is the example: SELECT SUBSTRING(user_email,POSITION('@' IN user_email) + 1) AS emai On Wed, Nov 4, 2009 at 10:42 PM, Guillaume Theoret wrote:

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....

On Wed, Nov 4, 2009 at 7:45 PM, Roman Sokolyuk 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

It's listed here: http://monetdb.cwi.nl/projects/monetdb//SQL/Documentation/SQL-Features.html#... On Fri, Nov 6, 2009 at 9:42 AM, Guillaume Theoret wrote:

Where did you find the POSITION keyword? I haven't seen any reference to it in the documentation.

On Thu, Nov 5, 2009 at 5:14 PM, Roman Sokolyuk wrote:

...

Actually,

I found a way to do it in SQL - here is the example:

SELECT SUBSTRING(user_email,POSITION('@' IN user_email) + 1) AS emai

On Wed, Nov 4, 2009 at 10:42 PM, Guillaume Theoret wrote:

...

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....

...

On Wed, Nov 4, 2009 at 7:45 PM, Roman Sokolyuk 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

------------------------------------------------------------------------------

...

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