Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From: InterBase/Interfaces/SQL    [ Add a report in this area ]  
Report #:  40652   Status: Need Feedback
like variable doesn't perform correctly
Project:  InterBase Build #:  latest release
Version:    8.0 Submitted By:   alan boiardi
Report Type:  Basic functionality failure Date Reported:  2/15/2007 11:38:34 AM
Severity:    Critical / Show Stopper Last Updated: 6/3/2008 5:13:03 PM
Platform:    All platforms Internal Tracking #:  
Resolution: Need More Info (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
i am in the process of migrating from interbase 5 to interbase 2007 all data transfered to new database and we have it a snag with one of our programmes

on interbase 5 we could run a query

select * from TABLENAME where ITEM LIKE '1234%'  and it would return 12345678

on interbase 2007 the same query in SQL console returns no data

i can't put % infront of statment as it will return the wrong set of data

any help please
this has halted my testing for now
Steps to Reproduce:
see above
Workarounds
None found as yet
Attachment
None
Comments

Sriram Balasubramanian at 3/30/2007 3:31:02 PM -
test with the ISQL commandline tool please, and let us know if you have the same problem.

Provide SQL steps with table metadata.

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.