Visual Query Builder Criteria for starts with

[cowannbell]

I'm using visual query builder and trying to figure out how the criteria field should look if I want to only see records that start with DP.

I know there is a STARTSWITH but that doesn't seem to work in the criteria field.

[CharlieS]

For that functionality, I believe you'll need to use the SQL Editor option instead of the Visual Query Builder. 

[danilang · Accepted solution]

Hi @cowannbell 

The following syntax should work in the criteria field for both SQL Server and Oracle.  Replace startstring with the text you're looking for 

Like 'startstring%'

Dan

[cowannbell]

Thank you so much, that did it.