I've got a SQL database which has a binary column containing a number (0 to 6). I want to use this number on an ASP page but what I get in the recordset doesn't seem tyo be any good.
I've tried selecting it as binary and also using CAST and CONVERT e.g. convert(int, status) but although the result can be output (e.g. response.write) I can't seem to use it in expressions. It behaves as null
Why How ... what do I do to get around it?