Like operator
Hi,
Can you just tell me how to use LIKE Operator(Syntax) please.I am new to SSRS2005.
September 25th, 2006 12:46pm
in what context? As part of your SQL query?
Free Windows Admin Tool Kit Click here and download it now
September 25th, 2006 2:05pm
Hi Adam,
I am getting some value from query.I want to use LIKE operator inlayout and check the value.
For example I am getting Email address from query.I want to validate '@'exisists or not.
Thanks Adam.
September 25th, 2006 5:10pm
you could use iif(instr(<field.value>, "@")>0, true-part, false-part)
Free Windows Admin Tool Kit Click here and download it now
September 25th, 2006 5:12pm
Yeah, I would probably use Iif(Fields!your_field.Value.Contains("@") ,true-part, false-part)
September 25th, 2006 7:30pm
I used the iif statement listed above because I could not get the LIKE operator to work as a table filter.
Free Windows Admin Tool Kit Click here and download it now
September 14th, 2007 9:10pm
The like operator in RS filters (such as table filters) uses VB-style syntax.
For example,
Filter expression: =Fields!Name.Value
Filter operator: Like
Filter value: T*
-- Robert
September 15th, 2007 12:58am
The like operator in RS filters (such as table filters) uses VB-style syntax.
For example,
Filter expression: Filter operator: Filter value:
=Fields!Name.Value Like P*
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2010 2:51am