Before I report it as a bug can someone confirm this for me. I'm checking to see if an email's sender matches a mask.

eg one entry in emBlackOrWhite is %yousave__.co.uk

LIKE only operates if the column is second

select * from emBlackOrWhite where :EMail like _EMail

returns one row but

select * from emBlackOrWhite where  _EMail like :Email

doesn't return any. I could be misinterpreting the manual

LIKE Returns True if the left string expression matches the right
pattern expression. ...

If so I'll have to work up a UDF to handle it.

Roy Lambert

Roy,

Is the _Email column the pattern ?  If so, then everything is fine.

Tim Young
Elevate Software
www.elevatesoft.com

Tim


Yup - it was me misreading/misinterpreting the manual - pattern on the right not the left.

Roy Lambert