Dynamic SQL Select

Question

So I was wondering how I can do this, I am using SQL Server Compact and need to do a specific thing.

I need to append a string to an int, resulting in a string if a column is not equal to a value

For example lets say I have this query here

SELECT id, Auto FROM example

Right now to get what I want I will have to do this select and then resolve it after like so

string id = dr["id"].ToString() + 
                dr["Auto"].ToString().IsNotNullOrWhitespace() 
                    ? " (Auto)" : "");

How can I get the same result in SQL? AS something like this

SELECT id ..... as id FROM example

(Auto is defined asINT NULL)

FabianCook · Accepted Answer · 2013-06-27 04:40:55Z

1

Not tested but you can try the following

SELECT (
        case id
             WHEN 1 
                  THEN id + ' (Auto)' 
             ELSE id END) as id 
FROM example

FabianCook

20.6k17 gold badges72 silver badges119 bronze badges

answered Jun 27, 2013 at 3:24

sarwar026

3,8413 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1