Hi,

I'm trying to create an SQL query using Excel as the datasource, the
query should either either replace one value with another or create a
new field on the basis of the first. My query is returning "A","B","C"
etc. but I want to alias this with another value e.g. "1","2","3" and
then make use of the aliased value elsewhere in the query.

I've tried using a CASE statement but this doesn't seem to be supported
when Excel is the datasource.....does anyone have any ideas how I can do
this?

Thanks


--
iain_m
------------------------------------------------------------------------
iain_m's Profile: http://www.excelforum.com/member.php...o&userid=34107
View this thread: http://www.excelforum.com/showthread...hreadid=538792