Like condition in where clause

How would I add a like condition to the where clause? The web service I am querying provides a set of tag names and values. I would like to limit the results where tagname like "%.windspeed" and value is not null. In this example, the wildcard would be the % symbol.