find char in string

[KryptoS]

Hey,

I have a table with a string field in it with those values:

ez-ha
fa, ra
fa
ka, dk
ka, fkr
ka-za
...

I want to creat a selecht where I only get the letters before the ',' ... and if there is no ',' in the string I need the whole string.
So I have to come to this:
ez-ha
fa
fa
ka
ka
ka-za
...

I just can't find out how I can get the position of the ',' in the string with sql :s

The One And Only KryptoS

 

[r937]

select case when locate(',',col) = 0
then col
else left(col,locate(',',col)-1) end

rudy

http://r937.com/

SQL Consulting