BETWEEN 'abc*' and 'xyz'

Hello Friends,

I need to select following stuff:

e.g All plants starting as abc1, abc2 abc3 ....etc and 'GGAZ'.

so in sql statemtns can I do like this...

SELECT bla bla FROM tab

INTO itab

WHERE ( matnr EQ lv_matnr

AND werks BETWEEN 'abc*' and 'GGAZ'.

Regards,