UPDATE left _

[anselme]

how can I can update a table ::
I must get all the left part of a columns part1_part2
I dont know how many characters

something like :

UPDATE Users SET Users.Info = left(Users.name, _ ??? or split('_'))



in that case Users.name = part1

thank you

[MAK]

what RDBMS?
if it is sql server then you can use LEFT function and CHARINDEX function to do it.

[anselme]

yes sorry MS SQL 2000

I must get all the left chars of '_' but I dont know how many
if you know how to do it ?

i must update only the one with a '_' and do nothing for the others

thank you

[nosepicker]

UPDATE Users SET Users.Info = LEFT(Users.name, CHARINDEX('_', Users.name) -1)
WHERE CHARINDEX('_', Users.name) > 0

[anselme]

perfect !

thanks a lot