Home Forums SQL Server 2008 SQL Server 2008 - General Upper all my code RE: Upper all my code
kanya.maddala
SSC Journeyman
Points: 88
More actions
October 24, 2016 at 2:59 am
#1908281
Try this if it works:
DECLARE @SQL_Upper as varchar(max)
SET @SQL_Upper = UPPER('Select * from MyTable where myVar = ''RED''')
Print(@SQL_Upper)