I have a powerbuilder application that was built to use 11.5 on unix. I have successfully rebuilt the database on 12.5 and am able to use the application. However it appears there are some problems in ASE 12.5 using % as a wildcard character in a select statement. Has anyone heard of this and know how to fix it.
The SQL works perfect in 11.5 but returns no records in 12.5 when using something like fieldname LIKE '%'
Well to add to this, I have determined indeed that even though a % should match 0 or more characters, in 12.5 it will only match 1 or more characters. Does anyone know if this is a setting somewhere that can be changed?