SELECT QUERY

[Freemo]

Hi,

Is it possible to add fields into a SELECT query in SQL based on whether the field contains data?

For example I dont want to display the field 'telephonenumber' unless there is a telephone number set.

Thanks

 

[ca8msm]

It would be possible, but not very economical and could cause quite a lot more overhead than necessary. I'd say you'd be better off returning the full resultset and using whatever package you are using to display the data to hide the columns.

Mark,

Darlington Web Design[tab]|[tab]Experts, Information, Ideas & Knowledge[tab]|[tab]ASP.NET Tips & Tricks

 

[Crowley16]

you mean if every single row in your returned data has null for telephone number?

in that case, no, well, not easily anyway, you'd need to use dynamic queries and other select to check.

normally, I'd do something in the front end for this sort of thing...

--------------------
Procrastinate Now!

 

[Freemo]

Thanks for the reply.

I need to extract the information in XML format and I am not sure how I can hide the field. I would like to automate it as much as possible.

 

[ddiamond]

Why don't you give an example of your xml input and desired output.

 

[markros]

XML TYPE('') ignores empty and NULL values in the field.

PluralSight Learning Library