Hi!

I need to modify a sql statement, I have a statement like this:

SELECT Name, MyID FROM Persons

Persons:
ID (PK,int,not null)
Name (varchar(250,not null))
MyID (varchar(10,null))

but some of the table entries lack MyID and what would i like is that the result of this select statement
would return 'XXXXXXXXXX' in MyID insted of null for the entries that lack MyID (without modifying db).


thanks alot!

SELECT Name, ISNULL(MyID, 'XXXXXXXXXX') AS MyID FROM Persons

thanks alot it works!, now i found out that i also have some entries with '' (empty string). is there an IF for that?

thanks again!!

...found CASE

SELECT
Name
, CASE (MyID)
    when '' then 'XXX'
        when null then 'XXX'
    Else MyID
    End
FROM Persons

thanks alot!

1) SELECT Name, CASE WHEN MyID > '' THEN MyID ELSE 'XXXXXXXXXX' END AS MyID FROM Persons
2) SELECT Name, ISNULL(NULLIF(MyID, ''), 'XXXXXXXXXX') AS MyID FROM Persons

Where is this output going???

--Jeff Moden

...to a DataReader, but I do not want to modify app or db, stored procedure is my best option.

thanks