i am using the below code but its not working .. what could be the reason?

CHARINDEX(@SPName,@DateAndIntCols)

to CHARINDEX function i am passing to variables, cant i pass variables to
CHARINDEX?

Please elaborate on "not working" . Are there errors? Don't you get expected
results? Don't you get any results? What?


ML

---
http://milambda.blogspot.com/

I am passing the below values to the variables but its still returning 0...
SET @SPName ='eUpdated'
SET @DateAndIntCols = 'eUpdated,eDeleted'
but its working (returning 1) when use the following one...
SET @DateAndIntCols = 'eUpdated,eDeleted'
CHARINDEX('eUpdated',@DateAndIntCols)



Show quoteHide quote

On Thu, 1 Dec 2005 16:03:03 -0800, KL wrote:

Hi KL,

Works for me:

DECLARE @SPName varchar(10), @DateAndIntCols varchar(100)
SET @SPName ='eUpdated'
SET @DateAndIntCols = 'eUpdated,eDeleted'

SELECT CHARINDEX(@SPName,@DateAndIntCols)


Can you please post your complete code?

Best, Hugo

Here is the code i am using .....

DECLARE
@SPName varchar(128) ,
@DateAndIntCols varchar(1000)
SELECT @SPName='eUpdated'
SELECT @DateAndIntCols=DateAndIntCols FROM MetaData WHERE SPID='CC-3'
SELECT CHARINDEX(@SPName,@DateAndIntCols)
And when i printed the variable @DateAndIntCols its showing as
'eUpdated,eDeleted'.....

Show quoteHide quote

Here is the complete code i am using .....
DECLARE
@SPName varchar(128) ,
@DateAndIntCols varchar(1000)
SELECT @SPName='eUpdated'
SELECT @DateAndIntCols=DateAndIntCols FROM MetaData WHERE SPID='CC-3'
SELECT CHARINDEX(@SPName,@DateAndIntCols)
And when i printed the variable @DateAndIntCols its showing as
'eUpdated,eDeleted'.....


Show quoteHide quote

On Thu, 1 Dec 2005 16:26:02 -0800, KL wrote:

Hi KL,

Since I don;t have your table, I had to add some lines to the script.
Here's what I executed:

CREATE TABLE MetaData
    (SPID char(4) NOT NULL PRIMARY KEY,
     DateAndIntCols varchar(1000) NOT NULL)
INSERT INTO MetaData (SPID, DateAndIntCols)
VALUES ('CC-3', 'eUpdated,eDeleted')
go
DECLARE
@SPName varchar(128) ,
@DateAndIntCols varchar(1000)
SELECT @SPName='eUpdated'
SELECT @DateAndIntCols=DateAndIntCols FROM MetaData WHERE SPID='CC-3'
SELECT CHARINDEX(@SPName,@DateAndIntCols)
go
DROP TABLE MetaData
go

And here's the output:


-----------
1

This is the expected output. What output are you getting? Also, what is
the output if you execute
  SELECT @@VERSION

Best, Hugo

On Thu, 1 Dec 2005 15:33:02 -0800, KL wrote:

Hi KL,

The following code returns 4 on my computer, which is as expected. What
are the values of @SPName and @DateAndIntCols in your case, and what was
the result you got?


DECLARE @SPName varchar(10), @DateAndIntCols varchar(100)
SET @SPName = 'xyz'
SET @DateAndIntCols = 'uvwxyzabcdef'

SELECT CHARINDEX(@SPName,@DateAndIntCols)

Best, Hugo

TSQL Debugger Oddity
Newbie:UNION with SELECT TOP
store image
DB design question.
Building View Dynamically .. Need Help!