troubleshooting Question

SQL Query syntax to CASE

Avatar of Aleks
AleksFlag for United States of America asked on
Web DevelopmentSQL
2 Comments1 Solution109 ViewsLast Modified:
I have code that updates a table, but when moving the data the size is larger than what our field allows.
I need to cast the field.

This is my current code, which works if the data was only 20 characters long.

UPDATE a
SET a.I797 = b.Description
from bluedot_eimmigration.dbo.Users a
INNER JOIN [bluedot_eimmigration].[dbo].[zzz_eimmigration_customdocuments] AS b ON b.userid = a.userid 
WHERE b.DocName = 'I-797'

I am trying to make the description 20 characters so that I can update without getting an error

UPDATE a
SET a.I797 = CAST(b.Description AS VARCHAR(20) ) AS Description , 
from bluedot_eimmigration.dbo.Users a
INNER JOIN [bluedot_eimmigration].[dbo].[zzz_eimmigration_customdocuments] AS b ON b.userid = a.userid 
WHERE b.DocName = 'I-797'

But the above gives me a syntax error:

Msg 156, Level 15, State 1, Line 15
Incorrect syntax near the keyword 'AS'.

Your help is appreciated.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros