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.
Solved! Go to Solution.
For that functionality, I believe you'll need to use the SQL Editor option instead of the Visual Query Builder.
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
Thank you so much, that did it.