You would need to write like follows: select case when PriceSec_National = 'Y' then 'Y' end as PriceSec_WesternCape
Since you can not replace fields from the query, only retrieve a column named like a table field Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ ismail cassiem schrieb: > 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278953 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
