Hello

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.

TYIA

Wind is your friend
Matt
www.elitemarquees.com.au

__________________
Wind is your friend
Matt

You can do it by using LIKE operator.
e.g:
  SELECT DISTINCT myStrigField FROM tblename WHERE myStringField LIKE 'ABC_D%' ORDER BY myStrigField

Than you for your time however this will get all records where the string contains 'ABC_D'

My question remains.... (frankly I dont think its possible, can anybody clarify this??)

TYIA

Wind is your friend
Matt
www.elitemarquees.com.au

I think following could help you, if I am wrong please correct me.

SELECT * FROM tblename WHERE myStringField LIKE 'ABC_D%' ORDER BY myStrigField


urt

Help yourself by helping someone.

urtrivedi - Thankyou for your time however your suggestion is the same as issaq's. This will not achieve the objective for the same reason in my last post.


Wind is your friend
Matt
www.elitemarquees.com.au

Apologies, I didnt look at your post very well did i....

Let me try that, looks logical to me.

Wind is your friend
Matt
www.elitemarquees.com.au