|
|
|
|
|
|
-
Ramesh Saive Commented 1 Years ago through Blogs
Very helpful article.
One question though, how can one specify a file mask like pur[0-9] or pur_?...
|
-
Ramesh Saive Commented 1 Years ago through Blogs
Very helpful article.
One question though, how can one specify the a file mask like pur[0-9] or pur_?...
|
-
Ramesh Saive Commented 1 Years ago through Blogs
Very helpful article.
One question though, how can one specify a file mask like pur[0-9] or pur_?...
|
-
Ramesh Saive Commented 1 Years ago through Blogs
Very helpful article.
One question though, how can one specify the a file mask like pur[0-9] or pur_?...
|
-
Ramesh Saive Commented 1 Years ago through Blogs
Replacing "]" with empty string will still have an issue for following set of data. And also you are not replacing the text in PATINDEX's data parameter.
Sample data:
declare @t table(data varchar(20))
insert into @t
select '9999999999999' unio...
|
-
Ramesh Saive Commented 1 Years ago through Blogs
Replacing "]" with empty string will still have an issue for following set of data. And also you are not replacing the text in PATINDEX's data parameter.
Sample data:
declare @t table(data varchar(20))
insert into @t
select '9999999999999' unio...
|
|
|
-
Ramesh Saive Commented 1 Years ago through Blogs
Just to note that this approach fails when the first character is "]" (i.e. closing square bracket).
The workaround is to replace such character with something like char(0) and then do the pattern search....
|