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 .
Filename: update.cmd
@echo off
cd /d %~dp0
echo ----------------------------- GETTING IP -----------------------------
wget "http://myip.dtdns.com" -o getip.log
type getip.log
del getip.log
if exist index.html (
set /p MYIP=<index.html
echo MYIP=%MYIP%
del index.html
echo ----------------------------- SETTING IP -----------------------------
wget "http://www.dtdns.com/api/autodns.cfm?id={domain}&pw={password}&ip=%MYIP%" -o setip.log
if exist "autodns.cfm*" del autodns.cfm*
type setip.log
del setip.log
)07/05/11, practice, 6:00 to 8:00 at EHS
07/06/11, practice game, 6:30 to 8:30 at EHS
07/07/11, practice, 6:00 to 8:00 at EHS
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. |