Hi, Can anyone help.
Is there anyway else to set the result field value temporary.
select
case when PriceSec_National = 'Y' then PriceSec_WesternCape = 'Y'
end as test
Sql error: Incorrect syntax near '='
Does not like to set another field.
eg Field1 Field2 TO Field1 Field2
Y X Y Y
Any ideas, or any other method please?
Thank You
Ismail
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278948
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
