Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.