creating a query

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

can I map a column created in the following manner in a where clause eg. select 'name' = fname + ' ' + mname + ' ' + lname from tab1 where 'name' is not null

I know the solution for the following as select 'name' = fname + ' ' + mname + ' ' + lname from tab1 where (fname + ' ' + mname + ' ' + lname )is not null

Can I bind a vaiable to a column in the similar manner

-- Anonymous, August 13, 2001

Answers

Russel,

You can do what you desire with a view.

Hope this helps,

Eric

-- Anonymous, August 21, 2001


Moderation questions? read the FAQ