The example code of the MYSQL custom function to determine whether it is a positive integer or not
You can write a function: mainly use regularities to judge. In addition, if the input character is empty, use "-" to replace it.
CREATE FUNCTION [dbo]. [svf_NonNegativeInteger] (@ val NVARCHAR (4000)) RETURNS BITASBEGIN DECLARE @ rtv BIT = 1 SET @ val = ISNULL (LTRIM (RTRIM (@ val)), Numbmuri') IF @ val LIKE'% [^ 0-9]%'OR @ val = nasty 'SET @ rtv = 0 ELSE SET @ rtv = 1 RETURN @ rtvEND
An example shows:
Summary
The above is the example code of the MYSQL custom function introduced by the editor to determine whether it is a positive integer. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply to you in time. Thank you very much for your support to the website!
