April 15, 2013 at 11:53 am
Hi,
Does anyone have a list of all the IS (date/numeric) type syntax available? I've been trying to find a resource that just lists them all out, but I guess I'm not phrasing my search correctly.
Thanks
April 15, 2013 at 12:45 pm
erikd (4/15/2013)
Hi,Does anyone have a list of all the IS (date/numeric) type syntax available? I've been trying to find a resource that just lists them all out, but I guess I'm not phrasing my search correctly.
Thanks
I think you did list them all out, both of them. ISDATE and ISNUMERIC are the only two I can think of. They are really only somewhat useful, well actually ISNUMERIC is pretty useless. It should be named ISValueSomethingThatCanBeConvertedToAnyDataTypeThatHasNumbersInIt.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 15, 2013 at 12:46 pm
Oh yeah ISNULL too.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 15, 2013 at 12:51 pm
Sean Lange (4/15/2013)
erikd (4/15/2013)
Hi,Does anyone have a list of all the IS (date/numeric) type syntax available? I've been trying to find a resource that just lists them all out, but I guess I'm not phrasing my search correctly.
Thanks
I think you did list them all out, both of them. ISDATE and ISNUMERIC are the only two I can think of. They are really only somewhat useful, well actually ISNUMERIC is pretty useless. It should be named ISValueSomethingThatCanBeConvertedToAnyDataTypeThatHasNumbersInIt.
Or to shorten the name ISValueSomethingThatCanBeConvertedToAnIndeterminateNumericType. Actually, I don't that that is any shorter.
April 15, 2013 at 12:51 pm
Really?! There's not an ISALPHA or anything to test for woogy symbols? That's... :unsure:
April 15, 2013 at 12:55 pm
erikd (4/15/2013)
Really?! There's not an ISALPHA or anything to test for woogy symbols? That's... :unsure:
ISAPLHA?? What would you be testing for? Not exactly sure what "woogy symbols" are.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 15, 2013 at 12:56 pm
Lynn Pettis (4/15/2013)
Sean Lange (4/15/2013)
erikd (4/15/2013)
Hi,Does anyone have a list of all the IS (date/numeric) type syntax available? I've been trying to find a resource that just lists them all out, but I guess I'm not phrasing my search correctly.
Thanks
I think you did list them all out, both of them. ISDATE and ISNUMERIC are the only two I can think of. They are really only somewhat useful, well actually ISNUMERIC is pretty useless. It should be named ISValueSomethingThatCanBeConvertedToAnyDataTypeThatHasNumbersInIt.
Or to shorten the name ISValueSomethingThatCanBeConvertedToAnIndeterminateNumericType. Actually, I don't that that is any shorter.
Maybe ISValueNumberish?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 15, 2013 at 1:16 pm
Sean Lange (4/15/2013)
erikd (4/15/2013)
Really?! There's not an ISALPHA or anything to test for woogy symbols? That's... :unsure:ISAPLHA?? What would you be testing for? Not exactly sure what "woogy symbols" are.
Er... things that aren't letters or numbers.
April 15, 2013 at 1:31 pm
erikd (4/15/2013)
Sean Lange (4/15/2013)
erikd (4/15/2013)
Really?! There's not an ISALPHA or anything to test for woogy symbols? That's... :unsure:ISAPLHA?? What would you be testing for? Not exactly sure what "woogy symbols" are.
Er... things that aren't letters or numbers.
That would be dependent on a number of things, mostly what language? What is not considered a letter by you may very well be a legitimate letter somebody else that speaks another language. If you mean a-z and 0-9 that is what regex is for.
The rules for setting up a built in function would be far more complicated than a quick test of your own.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 15, 2013 at 1:42 pm
Sean Lange (4/15/2013)
erikd (4/15/2013)
Sean Lange (4/15/2013)
erikd (4/15/2013)
Really?! There's not an ISALPHA or anything to test for woogy symbols? That's... :unsure:ISAPLHA?? What would you be testing for? Not exactly sure what "woogy symbols" are.
Er... things that aren't letters or numbers.
That would be dependent on a number of things, mostly what language? What is not considered a letter by you may very well be a legitimate letter somebody else that speaks another language. If you mean a-z and 0-9 that is what regex is for.
The rules for setting up a built in function would be far more complicated than a quick test of your own.
English, 95% of the time. I'm not talking about Unicode foreign language characters (finally). I'm mostly talking about ~!@#$%^&*()-_=+[{]}\|;:'",<.>/? and sometimes `. You know, those guys.
I (sort of) get regex, and have a function that I believe I found on here for removing non-alphanumeric characters from strings (let me know if my terminology is wrong; the script was called parsealhpa). But it doesn't do anything other than clean them out. Like, I couldn't use it to just write a query that would find a value containing something outside of the patindex, or include/exclude values based on if they have not-letter-or-number-squiggly-lines in them
I guess I was wondering if there was a more smarterer way of doing things
CREATE FUNCTION [dbo].[ParseAlpha]
(
@string VARCHAR(8000)
)
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @IncorrectCharLoc SMALLINT
SET @IncorrectCharLoc = PATINDEX('%[^0-9A-Za-z]%', @string)
WHILE @IncorrectCharLoc > 0
BEGIN
SET @string = STUFF(@string, @IncorrectCharLoc, 1, '')
SET @IncorrectCharLoc = PATINDEX('%[^0-9A-Za-z]%', @string)
END
SET @string = @string
RETURN @string
END
April 15, 2013 at 1:58 pm
Well you could create your own IsAlpha. I would extend the version you found to at least include spaces and periods.
something like this might help you along.
declare @ScalarVal varchar(100) = '123.'
select case when @ScalarVal not like '%[^a-z0-9 .]%' then 1 else 0 end as IsAlpha
You could turn that into a function if you wanted.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 15, 2013 at 2:02 pm
Sean Lange (4/15/2013)
Well you could create your own IsAlpha. I would extend the version you found to at least include spaces and periods.something like this might help you along.
declare @ScalarVal varchar(100) = '123.'
select case when @ScalarVal not like '%[^a-z0-9 .]%' then 1 else 0 end as IsAlpha
You could turn that into a function if you wanted.
It does. Thanks.
Viewing 12 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy