creating a querygreenspun.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 nullI 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
Russel,You can do what you desire with a view.
Hope this helps,
Eric
-- Anonymous, August 21, 2001