On Wednesday 26 October 2005 09:20, duschhaube wrote: > Hi! > > > Is it possible to use regular expressions in a select statement. > > for example select * from test where name="a*b" > > ciao
Maybe its just your example, but what you're asking for is for all rows where the field name matches the string "a*b". That is, Name is a string. Is that really what you are trying to do, or did you mean can you prepare a statement like "SELECT * FROM test WHERE name = ?" then when you execute it, you pass in your variable... Is that what you wanted? -- Michael Segel Principal MSCC (312) 952-8175