0

I'm using LIKE operator in crystal reports to retrieve some records. For example:

If i use LIKE 'ser' it should've brought records like this:

'loser' 'losér' 'losêr' 'losër'

But only 'loser' is retrieved, ignoring the rest. If i execute the query on sql management studio, it works normally.

I've found that crystal doesn't accept wildcards the same way as the management studio does...feek free to correct me if i'm wrong here. Is there any workarounds?

I'm using crystal reports 10.

Joao Victor
  • 1,111
  • 4
  • 19
  • 39
  • 1
    Have you considered a [regular expression](http://www.regular-expressions.info/unicode.html)? – craig Aug 30 '13 at 16:24
  • @craig Is there a regex UFL or are you talking about doing this in SQL? – Ryan Aug 30 '13 at 16:48
  • @Ryan: using the database would be more efficient, but there is also a [UFL](http://sourceforge.net/projects/cruflregex/files). The hardest part is constructing a regex that will allow for variation in vowels. You might have to explicitly list the Unicode values in the expression. – craig Aug 30 '13 at 23:38
  • If you are using Oracle, this might help: [regexp for all accented characters in Oracle][1] [1]: http://stackoverflow.com/questions/9020610/regexp-for-all-accented-characters-in-oracle – craig Aug 31 '13 at 05:46
  • I'm using sql server. The thing is...the column that has accented characters is set to be accent_insensitive. But it seems like crystal reports 10 doesn't support this. I created a .ttx file and used it as my database file. Kinda brutal but it worked. – Joao Victor Sep 02 '13 at 20:01

3 Answers3

3

try

LIKE '*ser*'

or 

LIKE '%ser%'
Lan
  • 1,335
  • 1
  • 9
  • 14
0

{dbo.VAriable} Like " * " & {?Paramiters} & " * "

Jeferson Lelis
  • 11
0

since 'e' is different in each of the above strings, you would need to compare it with %sër,%sér and %sêr or you could try '%s%r%'

Shyamal
  • 21
  • 3