Store Procedure to split a string and Pass as arguments

Question

0.00/5 (No votes)

See more:

Hi,

I am new to sql.

I want to create a procedure that splits the incoming string with respect to space and apply 'AND' between each of the word and retrive the ('%'like'%') rows from a table.

Can anyone help me.

Thanks

Posted 24-Jan-11 16:43pm

karthi34

Updated 24-Jan-11 22:30pm

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 25-Jan-11 4:30am

Edited for Readability.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wild-Programmer · Accepted Answer · 2011-01-24T22:15:00

Solution 1

Please check this thread @ how to extract comma seperated values in sp using SQL server 2000[^]

Posted 24-Jan-11 22:15pm

Wild-Programmer

Comments

Dalek Dave 25-Jan-11 4:31am

Good Link.

Wild-Programmer 25-Jan-11 4:40am

Thanks Dave :)

karthi34 27-Jan-11 12:53pm

Thanks Dave. Here i Want to pass a the table in side LIKE. Is it possible? here the query..
select * from tablename where f1 LIKE(select * from function_name(@param)).

I tried using IN but it results only exact matching but i need to have AND operation between the table values returned by the sub query .

Store Procedure to split a string and Pass as arguments

1 solution

Solution 1

Add your solution here

Preview 0

Store Procedure to split a string and Pass as arguments

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us