Replace values 1

[emoongq]

Hello I'm creating a view in which I need to replace values in a field named status from 'M' to 'C', is it possible, how?

Tks

 

[AlexCuse]

Instead of selecting the status column, select something like this:

case status
when 'M' then 'C'
else status end

For more info, look up CASE in BOL.

Hope it helps,

Alex


Ignorance of certain subjects is a great part of wisdom

 

[emoongq]

I'm not able to save the view or even run it on a DTS, any idea?

Tks

 

[AlexCuse]

Ah, seems you are using enterprise mangler. I believe I have run into this problem before (unable to use CASE to create a view).

What you will need to do is create your view from query analyzer. It will be something like this:

create view myView as

--enter your query here
select * from someTable

The query you type should of course use the CASE statement. For more info look up CREATE VIEW in BOL.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom