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 <romsok.tech@gmail.com> 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 <smokinn@gmail.com>
> 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.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
>
>
> ------------------------------------------------------------------------------
> 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