11-13-2012 02:41 PM
A quick question about how to code an SQL:
I have a prefix value (a data set name) in one table, and a fully qualified name (including the member name and extension) in a second table.
Is there a way to code a SQL to match these? I thought to use something like:
where a.prefix =: b.dsn
but this will not work.
I am not concerned whether the fully qualified name contains multiple sub directories, as long as the prefix matches.
Thanks in advance.