How to you specify wild cards as a criteria for a view? 1

[Rahel]

I have reference field that I need to filter some records based on two different criterias. <br><br>For example, if I wanted to filter for reference numbers that end with 'zzz', how do I specify the criteria ('*zzz' as the criteria does not work)?<br><br>For example, if I wanted to filter for reference numbers that begin with 'HR', how do I specify the criteria ('HR*' as the criteria does not work)?<br><br>I would be grateful if someone could point me in the right direction.<br><br>These reference numbers could vary between 6 to 12 characters, there is no fixed length.<br><br>

 

[ColinM]

Use % instead of * in SQL Server and like instead of =<br>i.e<br><br>Select Name,Address from Customers where Name = 'S*'<br><br>should be written as<br><br>Select Name,Address from Customers where Name like 'S%'<br><br><br><br>