an if clause in a sql query

[wengang]

hi all.
I'm just wondering if I can reduce the recordset size on my web page.

I have a query like:
select Top 50 ID, Field1,field2,field3 from tblRecords where....

Field1 in this example is very large text field, and since there are 50, the page is slow.

In fact, I don't need the text field to be returned, what I need is a true or false value to indicate if a substring is present in the field. And I do need the other fields. So I can't restrict this in the where clause.

What I need is:
Select Top 50 ID, Field2, Field3, (if field1 like '%MyPhrase%' Then True Else False) where....

So the top 50 records are returned, but instead of the big text field of data, a True or False is returned per record.

Is that possible? Cast the field type somehow?

Anybody know this? Thanks.

Wengang