Print Page | Close Window

Wildcard in different Databases Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Technical Questions Forum Discription: Formulas, charting data, Crystal syntax, etc. URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5628 Printed Date: 03 May 2024 at 3:37am Topic: Wildcard in different Databases Posted By: Jakki2 Subject: Wildcard in different Databases Date Posted: 27 Feb 2009 at 12:58am morning, i need to get confirmation on one issue. Once i create a record selection bases on LIKE with wildcard (status LIKE "Sched*", it will produce correct output with SQL DB but not with Oracle. This needs to be "feature" but how i'm supposed to circumvent this ? THanks, Jake Replies: Posted By: AntDC Date Posted: 27 Feb 2009 at 3:46am (status LIKE "Sched*" ) or (status LIKE "Sched%" )  --Oracle syntax or etc..etc.. Posted By: Jakki2 Date Posted: 27 Feb 2009 at 5:06am Hi, i tried both with oracle - either of styles didn't work ? THere is AR System where that query goes - does it make any difference ?

Print Page | Close Window