Thread: Excel replace text.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
  
Posts: 593
Default Excel replace text.
.... or even:

SELECT
MyIntCol,
SWITCH(
MyIntCol=4,'daily',
MyIntCol=8,'weekly',
MyIntCol=16,'monthly')
AS frequency_test
FROM
MyTable
;

Jamie.

--
Reply With QuoteReply With Quote