LabVIEW Database Connectivity Toolkit Parameterized Query Property Wildcard

[JensM]

Hi,

within my LabVIEW application I successfully implemented a SQL statement
like

SELECT *
FROM table_name
WHERE property 1 = 123
AND property2 = "abc"

with help of the Database Connectivity Toolkit. I first created a parameterized
query, then set each parameter and afterwards executed this query.

But now I want to use wildcards within this statement. Does anybody know
how to use wildcards with both integer properties and string properties?
Is this possible while using the normal parameterized query vi?

Thanks in advance for your help.

Regards

Michael

[becktho]

Hi Michael

You can use "LIKE":

SELECT * FROM table_name WHERE property 1 LIKE '12%'

% represents multiple characters (e.g. entries with property 1 123 but also 1240 would be selected)
_ represents one character

Hope this helps.

Thomas

Message Edited by becktho on 09-05-2005 11:57 AM