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 |
|
master640
Starting Member
6 Posts |
 Posted - 2008-04-03 : 15:13:57
|
| IN ACCESS UPDATE 14_Together_final_ICNs INNER JOIN 14_Together_UniqueSKUs ON [14_Together_final_ICNs].SKU = [14_Together_UniqueSKUs].SKU SET [14_Together_final_ICNs].sku_desc = [14_Together_UniqueSKUs].NewDescWHERE (((Trim(Nz([NewDesc])))<>""));THIS IS WHAT I TRY IN SQL SEVER BUT GET A DIFFERNET RESULT UPDATE [14_Together_final_ICNs]SET sku_desc = [14_Together_UniqueSKUs].NewDescFROM [14_Together_final_ICNs] INNER JOIN [14_Together_UniqueSKUs] ON [14_Together_final_ICNs].SKU = [14_Together_UniqueSKUs].SKUWHERE (RTRIM(LTRIM([14_Together_final_ICNs].sku_desc))<> N'') |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-04-03 : 16:41:02
|
| You forgot to convert the NZ() function, which would be either ISNULL() or COALESCE() in T-SQL.- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
|
|
|
(((Trim(Nz