the bottom line: you may need to use regular expression. However, I'm not
sure it's performance. Also, it is not portable. So, if not really
required, I do not use it.
a simple minded solution: just use "or":
select * from mytable where note = 'LM741CNSGS' or note = 'LM741CN-SGS';
the table name and filed name is not the same as yours. please give us
your "create table" so that we can cut/paste.
On Thu, 2 Dec 1999, Tom Techoueyres wrote:
> Hi,
>
> I am using a cursor search using sql queries to get information from a
> database that has 5 fields. The search is done on one of the fields which
> are "electronic components parts".
> My users usually type in the all part number they are looking for in the
> form.
> Here is the situation I have, lets say that a user is looking for part
> 'LM741CN-SGS', I have the follwoing queries:
> - select * from inventory where partno like 'LM741CN-SGS' (exact search)
> - select * from inventory where partno like 'LM741CN-SGS%' (partial search)
> - select * from inventory where partno like '%LM741CN-SGS%' (extended
> search)
>
> Now I need to create a query that when the user looks for 'LM741CNSGS', the
> result comes back with all rows with 'LM741CN-SGS' and and all rows with
> 'LM741CNSGS'.
> What would the suggested sql query to provide that type of result?
>
> I would appreciate any feedback.
>
> Thank you,
>
> Tom Techoueyres
> tom@eurobase.net
>
>
> ************
>