Greetings All,

Firebird 1.53 (Still)

I have a CLT_REF_NO like 700317012-0000 or 1586471932548-0500

Using a stored procedure I need to remove the dash and anything after it.

So 700317012-0000 would be 700317012 and 1586471932548-0500 would be
1586471932548

Any help or tips appreciated,
Mike