I am having some problems changing my select statement using wildcards.

This is what I had:

and studentcourse.courseid like "%2000EE%";


and it worked fine, but now I have to change it to be more flexible and not hard coded in so I want to change it to something like this:

and studentcourse.courseid like "%str(year(date())) + "EE"%";

I can't figure out the syntax to get it to work. I know its an easy fix, can someone please help.

TIA,
Tyler