|query-by-example and trim? [message #641025]
||Tue, 23 November 2010 18:18
Registered: November 2010
I have a db field (varchar) that may or may not contain leading and trailing spaces.|
I would like to use query-by-example using this field as part of the object's example criteria but I need some way to tell the example to trim the field. A simple sql query would use: trim(name) = 'bob'
Is there any way to configure the query by example to do this? Maybe using some flavor of QueryByExamplePolicy?
As always, thanks in advance.
Powered by FUDForum
. Page generated in 0.01567 seconds