Thanks for your help, guys 

Here's what actually works, the only question now is whether we can do date-arithmetic on chars . . ....

Unfortunately if I don't do the CAST the query runs okay to create the view, but when I try to look at the data I get "Error converting data type...

Yup, this is exactly what I was after thanks!

This is awesome, thanks!

SELECT * FROM users WHERE clue > 0

0 rows returned.

Yup, I realize this would be a kludge but I am getting desperate. The application is an ASP.NET page, the control that displays the data is a DataGrid -...