Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bferriter
Starting Member
34 Posts |
 Posted - 2005-05-11 : 10:28:55
|
| I want to show the bit column of a table in a listbox, but it only displays it as 0 or -1, not yes or no. The table has a standard bit column, no nulls allowed, default is 0. the list box entries are based off a query that selects the columns. I was hoping there was a way to specify in the listbox properties or the query properties what 0 and -1 translated too..any ideas?--------------------BrianOne man with 5 hats. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-05-11 : 11:13:51
|
| Not sure what options you have for formatting for a list box. Might be easiest to edit your query and translate the bit value into a string value:select ...., IIF(bitValue = 0, "No","Yes") as bitDisplayfrom ....- Jeff |
 |
|
|
bferriter
Starting Member
34 Posts |
Posted - 2005-05-11 : 11:22:27
|
| Your the man. :)--------------------BrianOne man with 5 hats. |
|
|
|
|
|
|
bit column expressed in a listbox