UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Case Statement, SQL Server 2012    
 
   
BentBrain
post Feb 18 2020, 04:00 AM
Post#1



Posts: 563
Joined: 10-February 03
From: Thailand


HI All,
Keep having issue with this Case Statement.
if i wrap it in STR or not I get this error
Conversion failed when converting the varchar value '**' to data type int.

Any Ideas.

CASE

WHEN ([tbl_Wait_Status].[WaitStatus] = 'Repair')

THEN (STR([tbl_Sales_OrderData].[JobOrderNO]) + STR('**'))

ELSE STR([tbl_Sales_OrderData].[JobOrderNO])

END


Thank you in advance.
BentBrain

--------------------
"There is no excellent beauty that hath not some strangeness in the proportion" Francis Bacon
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    30th May 2020 - 09:02 PM