Can you have a calculated field in a SQL table? 1

[tburrows]

I am using Access to access a SQL table. What I am trying to do is that I have a date field called DateCleared. I have another field called Cleared. What I want to do is that if DateCleared is empty then Cleared is No and if DateCleared has a date in it then Cleared is Yes.
I am familiar with Access but new to SQL.

Thanks
Tom

 

[mrdenny]

Yes, you can have a calculated column in SQL Server. In the design view of the table in Enterprise Manager select the column you want to set, then select the forumla line below. Then enter the T/SQL forum you want.

For example:
case when DateCleared is null then 'No' else 'Yes' end

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[tburrows]

Worked great.
Thanks

Tom

 

[mrdenny]

no problem

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)