Invalid Column Name on Case Statement 1

[LeonelSanchezJr]

I am getting an invalid column name on INLND_BL,
PO, HAWB, and POD. Any idea why?

Declare @SQL nVarChar(1024)
Set @SQL =
'Select
Hawb.cHawbNum
, Hawb.dShipDate
, Hawb.cOrigin
, Hawb.cDestin
, HawbDetail.cCustcode
, HawbDetail.dDueDate
, #TmpHawbsNoDoc.cDocType
From Hawb (nolock)
Join HawbDetail (nolock) on Hawb.cHawbNum = HawbDetail.cHawbNum
Join #TmpHawbsNoDoc On Hawb.cHawbNum = #TmpHawbsNoDoc.cHawbNum
Order By ' +
Case @cDocType
When Null Then 'cCustCode, cOrigin, dShipDate'
When "INLND_BL" Then 'cCustCode, cOrigin, dShipDate'
When "PO" Then 'cCustCode, cOrigin, dShipDate'
When "HAWB" Then 'cCustCode, cOrigin, dShipDate'
When "POD" Then 'cCustCode, cDestin, dShipDate'
End

Exec Sp_ExecuteSQL @SQL

 

[tlbroadbent]

You probably have quoted identifiers set ON. Add the following line at the front of your T-SQL script.

SET QUOTED_IDENTIFIER OFF Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.

 

[LeonelSanchezJr]

I'm still getting this error. Help.

 

[tlbroadbent]

Change the " to ' around the values in the When clause.

When 'INLND_BL' Then 'cCustCode, cOrigin, dShipDate'
Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.