Hi,

I need to bring back a row of results, all the fields are straight forward returns, however one field needs to be dynamic, I need to check the field, if something is there, return the value, however if nothing is there, to display a different value

Something like this

select field1
, field2
, (IF field3 IS NOT NULL field3 else 'No value') AS TheResult
from Tbl1

Anytime I try it always errors saying error with IF.

Any ideas how to do this?

Ad

I say just return the field values as normal, and do the conditional evaluation in the script to diplay field value or else value. As in php, you could evaluate the row field like:

echo ($row['field3'] != "") ? $row['field3'] : 'No Value';

Thanks!

I was trying to get all the logic for table manipulation in the stored proc to keep front end simple though, I have to display it in a few different ways (Excel, Access, Web) and dont want to put db logic in the front ends.

DaDon

What database are you using ??

Kindly specify the Database you are using as your backend.