from the Query u've posted. I think if u pass a particular number then u shd be getting the next number

for example, in a series of numbers...

Hi,

 My Specific Doubt was in terms of Execution of the Stmt Set @a = 1 and Select @a = 1

one of my colleague told that when...

HI Chris,

Thanks a lot.. I didn't know that we can do that by the way u've told.. i've made it very complex..

Anyways thanks a lot chris.. and sorry for wasting...

Hi Chris,

Thanks for your reply

but when i tried executing this SP with the syantax mentioned by you. I am getting an error saying incorrect syntax near  +

CREATE proc sp_cp

(

 @usr_id varchar(50)

)

as

begin

Execute sp_executesql...

This one also works

Select name,* from database..sysobjects where type = 'U'

Hi thanks for the reply

let me reframe my Question like this

Assume that an user enters Chinese Character like "?" ( Which is Equal to the word "PING" in English) and wants this...