RE: change binary values 1/0 to T/F in a SQL query? Possible?

2002-08-19 Thread Dave Watts
I think I have seen this before... Does anyone know if it is possible to get SQL (MS SQL 7 server) to dynamically change the value of a column? I need to change binary values 1/0 to T/F in a SQL statement. I am looking for something like: Select Fname, lname, IF (member){ T else F}

RE: change binary values 1/0 to T/F in a SQL query? Possible?

2002-08-19 Thread Mark W. Breneman
: Monday, August 19, 2002 12:17 PM To: CF-Talk Subject: RE: change binary values 1/0 to T/F in a SQL query? Possible? I think I have seen this before... Does anyone know if it is possible to get SQL (MS SQL 7 server) to dynamically change the value of a column? I need to change binary values 1/0