[QUOTE]The query is:
BEGIN TRY
UPDATE tdw
SET
tdw.tdwuid = LTRIM(RTRIM([tdw].[tdwuid])),
tdw.carrier_name = upper(LTRIM(RTRIM([tdw].[carrier_name]))),
tdw.seller_name = upper(LTRIM(RTRIM([tdw].[seller_name]))),
tdw.buyer_name = upper(LTRIM(RTRIM([tdw].[buyer_name]))),
tdw.origin_code = LTRIM(RTRIM([tdw].[origin_code])),
tdw.origin_option = LTRIM(RTRIM([tdw].[origin_option])),
tdw.destination_code = LTRIM(RTRIM([tdw].[destination_code])),
tdw.dest_option = LTRIM(RTRIM([tdw].[dest_option])),
tdw.mode_code = LTRIM(RTRIM([tdw].[mode_code])),
manifest_date = convert(varchar(10),cast(cast(manifest_date as varchar(12)) as datetime),101)
WHERE
tdw.report_state='IL' AND
tdw.report_year=2012 AND
tdw.report_month=7
END TRY
BEGIN CATCH
PRINT ' ERROR NUMER : ' + CAST(ERROR_NUMBER() AS VARCHAR(10));
PRINT ' ERROR MESSAGE : ' + ERROR_MESSAGE();
PRINT ' ERROR SEVERITY : '+ CAST(ERROR_SEVERITY() AS VARCHAR(10));
PRINT ' ERROR STATE : ' + CAST(ERROR_STATE() AS VARCHAR(10));
PRINT ' ERROR LINE ; ' + CAST (ERROR_LINE() AS VARCHAR(10));
END CATCH[/QUOTE]