The last time I checked AS/400 was an IBM Mid-Frame operating system. What database software
is being used? DB2? Oracle? Something else?
Anyway, if the DB software being used is some form of SQL database, then yes, you can do all the
things you asked. I’ll be glad to give examples if you can provide more specific information about
the database software.
One query that I could use (MSSQL query) would find all records that have “digit or signs” in the customer_name column of the customer table and would be formed like this:
<b>select * from customer where customer_name like ‘%[12@-&]%'</b>