Experts Exchange connects you with the people and services you need so you can get back to work.
CREATE FUNCTION IsNumeric (
modifies sql data
-- Scratch variables used for processing
DECLARE stringLength INT;
DECLARE loopCounter INT;
DECLARE charAtPos VARCHAR(1);
-- If the incoming string is NULL, return 0
IF (inString IS NULL) THEN
-- Initialize the scratch variables
SET stringLength = LENGTH(inString);
SET loopCounter = 1;
-- Loop over the string
WHILE (loopCounter <= stringLength) DO
-- Get the single character off the string
SET charAtPos = LOWER(SUBSTRING (inString, loopCounter, 1));
IF ((CharAtPos < '0') or (CharAtPos > '9')) then
SET loopCounter = loopCounter + 1;
-- Return the final output
Open in new window
Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.