SELECT RECORDS FROM COMMENT FIELD

[jobillborf]

Hi, using version 11. I would like to view all records that have the word INTERNAL in upper and/or lower case in a comments field. The word INTERNAL can be anywhere in the comments.

 

[jobillborf]

database used is oracle. Thanks for your help

 

[synapsevampire]

In the Report->selection formulas->Record try:

instr({table.field},"INTERNAL") > 0

You could also use real SQL by using a Command Object instead of using the Crystal GUI.

-k

 

[lbass]

Try:

{table.comments} like "*INTERNAL*" or
{table.comments} like "*internal*"

This should pass to the SQL. (Gotcha, SV-- )

-LB

 

[synapsevampire]

<chuckling>

Well it doesn't pass here, LB, using CR XI.

However you can do easily offload processing to the database by using a SQL Expression of:

INSTR(UPPER(out_val),'INTERENAL'))

Then in the record selection formula state:

{%MySQLExpression} > 0

It should all pass nicely.

-k

 

[lbass]

Funny, I tested my suggestion here with XI and it did pass.

-LB

 

[synapsevampire]

Hmmm, yeah, it seems it should pass now that I think about it...

-k

 

[jobillborf]

hi, I'm a little confused. I tried the first example and it did not work in version 11 it worked in version 9. Where do I place
INSTR(UPPER(out_val),'INTERENAL'))
and please define (out_val).


if I understand right
{%MySQLExpression} > 0 would be placed in the select statement.

Thank YOu .

 

[lbass]

I think SV meant:

instr(ucase(table.`field`),'INTERNAL')

You can either create that in the SQL expression expert and then set it > 0 in the record selection formula or you can try my suggestion. Either one will pass to the SQL.

-LB