anthony.green (10/22/2015)

---

Us an OR to search the exact string

Just uncomment a particular string at the top you want to search

--declare @searchstring varchar(100) = '\\Dpo-doctest1\Citibank Files\Citibank\07-JULY\20150703\C12'

--declare @searchstring varchar(100) = '\\Dpo-doctest1\Citibank Files\Citibank\07-JULY\20150703\C12\29P'

--declare...

anthony.green (10/22/2015)

---

Initial way would be to reverse the string, find the first \ strip out the remaining characters and compare.

Something like this

create table #TRFile (filepath varchar(100))

insert into #TRFile ...

Dana Medley (7/22/2013)

---

Maybe this will help.

SELECT 1234 AS '@TranID', 'ABC123' AS '@OrderNum',

'MY' AS 'Current_Location',

(

SELECT 'OK' AS '@Code', 'FINE' AS '@Reason_Code', 'KUU1234' AS 'Remark'

FOR XML PATH('Status'), TYPE

) AS...

is that have any others method?

eg: convert or cast?

because i involve many changes ....

shanu.hoosen (1/20/2010)

---

run this sql

declare @s-2 nvarchar(200)

set @s-2= '[Q1 ''10] ,[Q2 ''10] ,[Q3 ''10] ,[Q4 ''10] '

select @s-2

--this is the result

[Q1 '10] ,[Q2 '10]...

knockyo (1/20/2010)

---

shanu.hoosen (1/19/2010)

---

Hi,

will this not work?

declare @selectColumns nvarchar(400)

declare @W nvarchar(200)

set @selectColumns ='[Q1 ''10] ,[Q2 ''10] ,[Q3 ''10] ...

shanu.hoosen (1/19/2010)

---

Hi,

will this not work?

declare @selectColumns nvarchar(400)

declare @W nvarchar(200)

set @selectColumns ='[Q1 ''10] ,[Q2 ''10] ,[Q3 ''10] ...