if then else

[pscassidy]

hi,

i get

incorrect syntax near 'then'

when i use this code:

Alter Procedure intranet_property_list

@orderby1 varchar(20),
@orderby1_direction varchar(4),
@orderby2 varchar(20),
@orderby2_direction varchar(4)

As
declare @sql varchar(100)
if @orderby1=@orderby2 then @sql="test"
select ref,county,estate_agent,short_description,price_punt,feature,no_bedrooms,category,address1
from properties
order by ref desc
return

 

[Cagliostro]

try without when, as in C++ Ion Filipski

filipski@excite.com

 

[tlbroadbent]

Check answer in thread183-129212 of SQL Server forum. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[bobham]

Does your SQL have 'CASE' ?

bobh

 

[Cagliostro]

is a mistake, I would print then instead of when Ion Filipski

filipski@excite.com