SQL REPLACE Statement (or similar) in MS Query
 

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