Using percent

FinalBuilder Discussion
1

I'm doing a LIKE statement and need to use a %, but FB can't get past thinking its a variable.

How do I get around this?

2

you need to escape %'s with another %, eg. your query could be:
Select * from Company where companyname like ‘micro%%’

.t8

3

Hmm.  I thought I did that...  I'll try again.