LIKE operator

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Sergio Perdichizzi Tue, 03 Dec 2002 21:19

#11149

Author: Sergio Perdichizzi
Date: Tue, 03 Dec 2002 21:19

8 lines
1220 bytes

Hello.
Can anyone give me a good example on how to use the LIKE operator in
interbase SQL?
I think it's used for something I need to do, but I can't make it work.
I need to select a VARCHAR field when the value begins with a string set.
Thanks a lot.

Sergio

Re: LIKE operator

#11150

Author: Bill Todd
Date: Tue, 03 Dec 2002 22:24

28 lines
1692 bytes

If you are looking for a field that begins with a string of characters
the best choice is:

SELECT * FROM SOME_TABLE
WHERE SOME_FIELD STARTING WITH 'ABC'

If you want ABC anywhere in the field use:

SELECT * FROM SOME_TABLE
WHERE SOME_FIELD LIKE '%ABC%'

On Tue, 3 Dec 2002 18:19:53 -0300, "Sergio Perdichizzi"
<sperdich@reliable.com.ar> wrote:

>Hello.
>Can anyone give me a good example on how to use the LIKE operator in
>interbase SQL?
>I think it's used for something I need to do, but I can't make it work.
>I need to select a VARCHAR field when the value begins with a string set.
>Thanks a lot.
>
>Sergio
>


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads