Forum Replies Created
Viewing 2 posts - 1 through 2 (of 2 total)
-
RE: How to find out a person is reached 21 years old?
Use a combination of datediff() and case functions. compare the date column with getdate()
ex.
select DATEDIFF ( year , '1980-9-3', getdate()), case when DATEDIFF ( year , '1980-9-3', getdate()) <=21 then...
-
RE: defining a dropdown list for a table field
Wouldn't it be a charm if such thing is possible?
So to answer your question: No, you can't enumerate values for specific columns...
Viewing 2 posts - 1 through 2 (of 2 total)