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.