Search for "*", not wildcard 1

[bobbyr]

I am trying to use Select Expert to select data that starts with * (an astrisk), but the Select Expert is selecting everything thinking that I'm specifying a wildcard. Any way around this?

Thanks,
Bobby

 

[rhinok]

[ol][li]If you can (depending on your database, driver and CR version), create a SQL Expression that substrings the first character of your data field[/li]

[li]Format your record selection statement like this:

{%SQLExpression} = '*'[/li][/ol]If you aren't concerned about performance at all, then you can simply use the following select statement:

Left({table.fieldname},1) = '*'

 

[synapsevampire]

Try:

{Customer.Customer Name} [1 TO 1] = "*"

That will pass the SQL and only return those with an asterisk in the first position.

Crystal is VERY persinickety about pass through SQL... The select expert does an OK job, but you have to experiment sometimes with creating a manual record selection criteria.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com