Hello, hoping someone can help me (SQL noob) with a basic search formula: Transaction search for Sales Orders (main line) where Shipping Address 1 field does not contain any numbers. This seems like it should be very simple. I've tried some variations on CASE or REGEXP but so far no luck. TIA!

The following should work:

CASE WHEN REGEXP_LIKE({shipaddress1}, '[[:digit:]]') THEN 0 ELSE 1 END

If Shipping Address 1 is empty, it will also match, though, as it doesn’t contain a number. You can remove the empty ones if you want with an additional filter.

this is great, thanks so much!!