Retrieve the word ‘EN’ and the subsequent string of numbers from the DESCRIPTION field in a database table tbl.
If the string does not contain ‘EN’, return null. The string of numbers may include digits and special characters like '/', '-', '+', '%', or '_'.
In SQL, the task can be completed using CROSS APPLY with XML syntax, but the code is complex and lengthy.
In SPL (Structured Pattern Language), the task can be achieved using string-splitting functions and ordered calculation functions with simple and easy-to-understand code.