sql query for string search

[abyss]

can any1 help me solving this nebbie problem?

i have a column of 'text' variables and i need find all lines which contain variable string value, for example "2004" or smth like that...

i guess it's smth like this?:

SELECT N.id, N.description
FROM N
WHERE N.description [contains a word ( StrICmp )] variable_string;

yeah.... .....

 

[Norie]

Just goto the query designer and enter *2004* as the criteria for the field you wish to search.

This would find/match all strings containing *2004*.

If you want to see what the SQL is just goto View>SQL View

 

[abyss]

but next time the search string may be "2000" or "Special edition"....

i've found a function [ALIKE] that does StrICmp, but as a parameter I pass "2004":

..where N.description Alike "2004"....

how to pass that 2004 from a comboBox ?

 

[abyss]

Found by myself.....

source if some1 needs...

SELECT [cdz].[nr], [cdz].[serial], [cdz].[cd descr]
FROM cdz
WHERE [cdz].[cd descr] ALike '%'+[search for string]+'%'
ORDER BY [nr];

 

[Norie]

Can you explain fully what you are trying to acheive?