Hi Grant

Yes, that will work, but with no space between your pipes(||)
(where (BD.FirstName||BD.LastName) = 'abc').

If you need a space add one like this : where (BD.FirstName||' '||
BD.LastName) = 'abc';

By doing that you will always be limited to un-indexed reads if you have an
index on any of those fields.

I would rather have one extra concatenated field(Prepare on insert) with a
index on it to make searches a bit faster.

Hope this helps

Louis


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Grant Brown
Sent: 03 June 2005 06:54 AM
To: Firbird Support Group
Subject: [firebird-support] where clause

Hi all,

in the where clause of a sql query is the following valid and is there a
better way to do it

where (BD.FirstName | | BD.LastName) = 'abc';

--
Regards,
Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au

SiteDoc - Easy to Use - Powerful Results



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links