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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics