Drew Jensen wrote:
John Jason Jordan wrote:
SELECT * FROM "MainBank" WHERE ( ( "Selections" LIKE '%LFc-___' ) )
ORDER BY SUBSTR( "Selections", LOCATE( 'LFc-', "Selections") + 4, 3)
ASC
forgort the most important part - or you will be pulling your hair out
on this.
If you use a function inside a function like this, the Base parser gets
wierded out - so.
Open the query in design mode, switch to SQL mode and then Click on 'Run
SQL Direct' it is on the toolbar the letters SQL with a green check mark.
Then you have to add the substr section by hand.
Otherwise you will get a syntax error from the Base parser - this way it
gets out of the way and just hands the query as a raw SQL statement to
the HSQLdb engine.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
