Sorry it's default
> -Original Message-
> From: Peter Brawley [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 16, 2002 5:23 PM
> To: Paul van Brouwershaven
> Subject: Re: SQL Query
>
>
> Please do NOT mark posted messages 'request reply'.
The number of values is also not the same, this can be 1 till +/-30
values
> -Original Message-
> From: Dennis Salguero [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 16, 2002 1:46 PM
> To: Paul van Brouwershaven; [EMAIL PROTECTED]
> Subject: Re: SQL Query
>
&
I'ts a dump of an other database with more than 4 million records
> -Original Message-
> From: Thoenen, Peter Mr. EPS
> [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 16, 2002 2:54 PM
> To: 'Paul van Brouwershaven'; [EMAIL PROTECTED]
> Subject: R
Hi,
I have a colum with this values :
,1,4,5,66,247,7,
,1,3,5,62,767,6,
,1,5,5,11
,1,9,5,36,7677,9,
,1,40,55,66,444,3,
I want to get whis values : (second field)
4
3
5
9
40
I have tried this :
REPLACE(SUBSTRING_INDEX(value, ',', 3), ',','')
But the following is returned :
14
13
