sql_regcase
sql_regcase
sql_regcase
- It make regular expression for case insensitive match
Syntax:
string sql_regcase ( string string)
It returns a valid regular expression which will match string, ignoring case. This expression is string with each character converted to a bracket expression; this bracket expression contains that character’s uppercase and lowercase form if applicable, otherwise it contains the original character twice.
Example:
echo sql_regcase (”test”);
It displays [Tt][Ee][Ss][Tt]
echo sql_regcase (”Test123″);
It displays [Tt][Ee][Ss][Tt]123
This can be used to achieve case insensitive pattern matching in products which support only case sensitive regular expressions.
