I'm using the wonderful AS400 DB2 for an SQL assignment (not by my choice!) and nobody in the class, the teacher included, can get the wildcard characters to work. If I remember correctly, it's a % for a * and an underscore for a single replacement character. I think I also have to use like instead of = when using a wildcard character but any way I write the statement, it won't run. For example, I know that "select * from team where teamnm like '%s%' will not return any results but it should cuz there's lots with an s in the name. I can't figure out what I'm missing but for an assignment we need to use them. I already used substr on one but another question is return all the records that end with a certain string so if anyone knows a test just the end trick or how to get wildcards to work, that'd be awesome.