Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would lik to extract several rows from a table using 'load...from where'.
The field I want to filter has 17 characters in all its rows , I would like to extract all of them starting by 'PPTO-' and ending by '-ene-2014' so I need a wildcard for the characters 6,7 and 8.
I do not know how to write script to do this.
Thanks
I think wildmatch() can help:
WHERE wildmatch(FieldName, 'PPTO-*-ene-2014')
I think wildmatch() can help:
WHERE wildmatch(FieldName, 'PPTO-*-ene-2014')
wildmatch(yourfield,'PPTO-*-ene-2014')
or
wildmatch(yourfield,'PPTO-???-ene-2014')