I want to use these wildcards in my stored procedure block as follows

Select * from your_table where your_field Like '%Some_variable%';



it is not working...Please help me out

Shailesh



Miroslav Penchev <miroslavp@...> wrote:

On Sat, 7 May 2005 22:20:04 +0200, John Jaabæk <johnjaab@...> wrote:

> Well, try this and see what kind of result you get:
>
> Select * from your_table where your_field Like '%m';
>
> Select * from your_table where your_field Like '%m%';
>
> Select * from your_table where your_field Like 'm%';
>

I still do not understand what the problem is. Of-course I can run these
selects and gets the results that I expected. What is your problem?

Cheers,
--
Miroslav Penchev


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

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

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


Yahoo! India Matrimony: Find your life partneronline.

[Non-text portions of this message have been removed]