• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 132
  • Last Modified:

I want to exclude values which contains string which has "<"

Here  DTQCResult  is  a  DataTable.
Some  time  it  happens  that  ResultValue comes  as ">50" or "<40" etc  so  I  want  to  exclude  those  values  which contains operators ">" or "<". I  was  successful  in  exclusing  ResultValue  that  comes  "NA". Please  help.
Following is  line  where  I  have  to  do  it.So  that  in  deSelectect  does  not  have  values  with ">" or this "<"

DataRow[] drSelectect = DTQCResult.Select("CheckCol=1 AND ResultValue <> 'NA'");

Open in new window


Please  it little  bit  urgent
0
ADITYA RAO
Asked:
ADITYA RAO
1 Solution
 
Rgonzo1971Commented:
HI,

pls try

DataRow[] drSelectect = DTQCResult.Select("CheckCol=1 AND ResultValue <> 'NA'" AND ResultValue NOT LIKE '*<*' AND ResultValue  NOT LIKE '*>*'");



Regards
0
 
ADITYA RAOSoftware DeveloperAuthor Commented:
Thank you very  much  it  worked  perfectly
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now