Well, first of all, "str(..." will pad with spaces to the left. Use either "alltrim(str(" or "transform(".
Second, you can't put "year(" within quotation marks. Your expression should be something like:
... LIKE "%" + transform(year(date()) + "EE%"
>
>
>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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)