Where clause

[amol2939]

I have a lab result and want to filter only character result value
Eg: O Positive
Pale yellow
Any idea how to filter

[ChrisNZ]

What's the criterion? 

No digits allowed? Only letters allowed? Punctuation allowed? Spaces allowed?

[amol2939]

Only letters allowed

[ChrisNZ]

O positive contains a space

[amol2939]

Space allowed
But no numeric value must be there

[ChrisNZ]

To test for numerics:

  where ^anydigit(VAR) ;

To test for non- letters and spaces:

  where ^prxmatch('/[^ a-zA-Z]/');

[amol2939]

Spaces allowed

[andreas_lds]

To stop guessing what you really need, please post data you have in usable form and the expected result.