SQL update query 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

 

[Mike Lewis]

Dano,

I would use a REPLACE. Something like this:

REPLACE MyField WITH SUBSTR(MyField,5) ;
FOR LEFT(MyField,4) = "UUU/"

You can of course modify this to take account of different prefixes, or to make it more general.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[JimWWinter]

Dano,

Perhaps the following construct would help?

RIGHT(cField,LEN(cField)-AT('\',cField))

Regards,
Jim

 

[teresas]

Dano,

If the "prefix" in your data always ends in "\", you can simply use JUSTSTEM() in a REPLACE statement.

Teresa