Discussion Board for collaboration related to QlikView App Development.
How could I search for all strings within OCWard which start with A and end with E? I was using this: -
IF(OCDestinationCode='1',0))) as ED_Ward2
But it doesn't find AYE, or A&E etc. What am I doing wrong?
Many thanks in advance.
Try to use
and see if it works
Works perfectly! Thank you very much.