sql - SAS FedSQL - regular expression -

i'm trying use regular expression inside sas data flux client, uses fed sql. code this:

select * dataset char_value "icm[def].*" 

in order match records char_value = icmd... or icme... or icmf... . doesn't seem understand regex, in fact returns 0 rows.can me?

after looking online sas synatax, saw not using correct syntax.

like operator should singlee quotes if matching string, , use % not * so:

select * dataset char_value 'icm[def]%' 

its untested, tell me if works(i'm not familiar [] if doesn't work can try 'icmd.%' or 'icme.%'....)

select * dateset char_value 'icmd%' or char_value 'icme%' or char_value 'icmf%'