Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-28 : 07:43:12
|
| JB writes "Hi,I have 2 tables, one called assets the other called codes,I need to update 5 fields in the assets table using data I would have to extract from the codes table and then substring.Heres what I have so far to update the 1st field, but I've never worked in DB2 before and can't seem to get this working.Update ASSETS SET ASSETS.WEARMETH = SUBSTRING(CODES.SHORTDESC,5,1)FROM CODESWHERE CODES.CODETYPE = 4 AND CODES.CODE = AS000000.ASSETGRPDESPERATLEY SEEKING THE CORRECT SYNTAX" |
|
|
|
|
|
DB2 UPDATE QUERY