Problem with LIKE Function

[txaccess]

I have recently started working in an Access Project environment and I am new to SQL. In plain old Access I have no problem with finding records that begin with "B" for example, but I just can't get this function working in Access Project. What is the correct syntax? I have tried building a stored procedure to act as a filter and used LIKE in the conditions column, e.g.

WHERE (cont_last LIKE N'B*')

But this returns zero records.
Any help apprecieted.

I haven't failed, I have just found 10,000 ways that it won't work!

 

[cmmrfrds]

The wildcard character is % in sql server.

Also, literals are denoted by single quotes not double quotes as in Access.

 

[txaccess]

Thanks cmmrfrds that worked a treat!

I haven't failed, I have just found 10,000 ways that it won't work!