Wildcard to filter whith 'where' condition

[#1]

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

[Anonymous · Accepted solution]

I think wildmatch() can help:

WHERE wildmatch(FieldName, 'PPTO-*-ene-2014')

[Clever_Anjos]

wildmatch(yourfield,'PPTO-*-ene-2014')

or

wildmatch(yourfield,'PPTO-???-ene-2014')