on the advanced recordset screen, change the where clause to:
WHERE IPAddress LIKE colname
edit the colname variable and set the type to Contains
Looks like this is a bug when using the simple recordset interface to create a contains query, i will log this in our system.