Search.. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Search..

Author

Topic

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2005-11-29 : 02:05:51

Hi,

I have following values in the database

Col 1

Move last
New record
Save record
Delete record
Refresh record
Default record

and from the Application i wud passing something like this ..

Move last Alt+1
New record Alt+2
Save record Shift+2
Delete record Shift+2
Refresh record Shift+3
Default record Shift+5

So is there any way i can get.... the values which are there in the database..?????

Thanks..

Sucess Comes to those who Believe in Beauty of their Dream..

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-29 : 02:25:26

Is this?

Select columns from yourTable where '%'+@searchStr+'%' like '%'+yourcol+'%'

Madhivanan

Failing to plan is Planning to fail

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2005-11-29 : 02:40:21

Ahah.. Thanks.. worked for me.. :-)))

Sucess Comes to those who Believe in Beauty of their Dream..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources