Re: Like operator and Parameter
From: Paul <paulsnewsgroups_at_hotmail.com>
Date: Sun, 24 Apr 2005 15:26:42 +0100
Message-ID: <o3bn61plflq9lq49o30jqd1ddmod19a3f0_at_4ax.com>
Date: Sun, 24 Apr 2005 15:26:42 +0100
Message-ID: <o3bn61plflq9lq49o30jqd1ddmod19a3f0_at_4ax.com>
[Quoted] DA Morgan <damorgan_at_x.washington.edu> wrote:
>where e LIKE '%' || :P_from_form || %';
>Should work just fine.
[Quoted] Surely '%' || :P_from_form || '%'; ? 8-)
Paul...
-- plinehan __at__ yahoo __dot__ __com__ XP Pro, SP 2, Oracle, 9.2.0.1.0 (Enterprise Ed.) Interbase 6.0.2.0; When asking database related questions, please give other posters some clues, like operating system, version of db being used and DDL. The exact text and/or number of error messages is useful (!= "it didn't work!"). Thanks. Furthermore, As a courtesy to those who spend time analyzing and attempting to help, please do not top post.Received on Sun Apr 24 2005 - 16:26:42 CEST