Can you compare strings in a where clause? EG:
SELECT DISTINCT myStrigField FROM tblename WHERE myStringField [starts with 'ABC_D'] ORDER BY myStrigField;"
mmmm, seems simple however is proving otherwise...
The objective of this query is to pull all distinct records that start with 'ABC_D'
The LEFT function (and other common string functions) seem to be used to massage the output syntax however I am having difficulty conditionaly selecting my record set. I am aware I can make this comparison while looping through the RS however would prefer to get just the records I need as described above.
Wind is your friend