Referring to a Computed column in WHERE clause

[rclawson]

Is it possible to do something like this?

select (BillPrefix + ' ' + BillNumber) as Bill
from Bills
where Bill like 'HF 3%'

I get an error when I execute this, but I want to be able to do a partial match over both columns. Is this something that could be done with a dynamic view (i.e., in the FROM clause). The user would enter text such as "HF 3".

Any thoughts?

RC

 

[fredericofonseca]

try
select (BillPrefix + ' ' + BillNumber) as Bill
from Bills
where (BillPrefix + ' ' + BillNumber) like 'HF 3%'

Note that if BillNumber is numeric then you need to use cast(BillNumber as char) instead

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[rclawson]

Thanks. That looks like that will do the trick.

RC