Pitching Drills
July 16,
2011
2011
Using PATINDEX to find character in a string.
July 12,
2011
2011
declare @test table ( id int identity(1,1) primary key clustered, value varchar(10) )
insert into @test (value)
select null union all
select '' union all
select '1' union all
select '-' union all
select '1.2' union all
select '1,23' union all
select ',' union all
select '.'
select * from @test where patindex( '%[,.-]%', value ) > 0
-- Should return
id value
----------- ----------
4 -
5 1.2
6 1,23
7 ,
8 .
Pronounced
[
ree
-
uh
l-
tahym
,
reel
-
]
–noun
Fishing
.
| of or pertaining to the period in which a fisherman must leave to go fishing. |
–adjective
Computers
.
| of or pertaining to applications in which the computer must respond as rapidly as required by the user or necessitated by the process being controlled. |