SQL Query : Ensuring <Search Term> has been populated ?

[Bumble]

Hi,
I'm new to Sparx and am after a bit of help please 

Is there a way when you are utilizing the <Search Term> in an SQL query, you can ensure  that it has been populated when the query runs ?
eg

 where t_diagram.Author LIKE '#WC#<Search Term>#WC#'

Thankyou !

[Geert Bellekens]

Adding

Code: [Select]

and len('<Search Term>') > 0seems to be working for SQL Server.  Should be the same in Access syntax (.eap and .eapx)

Geert

[Bumble]

 I will give that a try.

Thanks for your help Geert