Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    2

    Unanswered: ASE 11.5 to ASE 12.5

    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 '%'

  2. #2
    Join Date
    May 2003
    Posts
    2
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •