WHERE first three letters equal xyz

[JapanFreak]

Hi there,

I have one question with regards to the WHERE part of an SQL query. I want to limit my query on datasets, where the first three letters of a certain field (which contains strings) equal "Exp". Is there a more efficient way than the following?

SELECT A.Date, A.Name
From tblA as A
WHERE A.Name="Exp_A" OR A.Name="Exp_B" OR A.Name="Exp_C";

Best regards,
JapanFreak

 

[Kempes]

have you tried

Like "exp*"

??

 

[JapanFreak]

Problem solved.

Uncle Gizmo,

thank you for your reply. I will consider that going forward.

Kempes,

thank you very much - yes, that works.

Best regards
JapanFreak