Re: [SQL] position(text,text) function

2001-07-23 Thread omid omoomi
position ( 'el' in 'hello') ; >From: [EMAIL PROTECTED] (Karl Orbell) >To: [EMAIL PROTECTED] >Subject: [SQL] position(text,text) function >Date: Mon, 23 Jul 2001 14:27:15 + (UTC) > >I'm having trouble using the position function, it's a simple

Re: [SQL] position(text,text) function

2001-07-23 Thread Dorin Grunberg
The correct way would be: select position('el' in 'Hello'); Dorin At 02:27 PM 7/23/01 +, Karl Orbell wrote: I'm having trouble using the position function, it's a simple built-in function. It returns the index of a substring within a main string. But, I just can't get it to work, it alway

[SQL] position(text,text) function

2001-07-23 Thread Karl Orbell
I'm having trouble using the position function, it's a simple built-in function. It returns the index of a substring within a main string. But, I just can't get it to work, it always gives this silly parser error. I've tried it in a variety of ways with variables instead of constants casting to