Help manipulating output string based on BIT value of field

jasonsalas · Jan 12, 2004

I think this is a formatting issue, but here's my dilemma. I've got a table with the following schema:

NAME INCUMBENT
VARCHAR(120) BIT

What I'd like to do is return a recordset wherein if a record has a value of "TRUE", then the name field will append certain HTML markup, like so:

SELECT * FROM TablePeople
------------------------------
NormalPerson
Incumbent *
AnotherNormalPerson
YetAnotherNormalPerson
AnotherIncumbent *

Do you know how I can query the same table and append this data?

Thanks much!

nigelrivett · Jan 13, 2004

You will probably need an order by clause:

select name + case when INCUMBENT = 1 then ' *' else '' end
from tbl
order by ?

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

jasonsalas · Jan 13, 2004

Thank you very much! That did it perfectly!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Help manipulating output string based on BIT value of field

jasonsalas

IS-IT--Management

nigelrivett

IS-IT--Management

jasonsalas

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor