Need some SQL update help

[Kruzer]

I need to update some records by removing prefixes from a value in several hundred records.

current value is "UUU\joeuser"

need the value to be "joeuser"

How would I write the SQL query to update multiple records in the database so that the prefix is removed?


UPDATE Table
SET dUser = '%\%'
WHERE column_name = some_value

Dano
What's your major malfunction

 

[carp]

UPDATE my_table
SET my_column = SUBSTR(my_column,5)
WHERE SUBSTR(my_column,1,4) = 'UUU\';

I

 

[PHV]

SET dUser = SUBSTRING(dUser FROM POSITION('/' IN dUser)+1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886