hi every one i have a question about LIKE keyword and it is that can i use LIKE For searching string in database.
Thanks In Advance.
YoOrD.

Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--

__________________
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;YoOrD .
Beauty is not on the face
Beauty is on the heart
~~&lt;&lt;Ghibran Khalil&gt;&gt;~~

Yes you can.

Yippie Ki Yea, Mr. Falcon.

You can... Look for LIKE operator in Books online for more help on that.

_________________________
- Vijay G
Strive for Perfection

thanks for your relpies i do it but i have below problems.
any idea
thanks in advance.

     YoOrD.
Beauty is not on the face
Beauty is on the heart
~~<<Ghibran Khalil>>~~

Can you explain that with example and the way you are trying to search?

_________________________
- Vijay G
Strive for Perfection

thanks for your replies
i like to search my DB table for a column that fit in a specific criteria but some times it is happen that between two words spaces occurs more than once or when type space and both search text and table column and i think i need in both of them first i convert delete all of extra spaces and left only one space and in search text too.
can you can i can use other ways to do this
thanks

       YoOrD.
Beauty is not on the face
Beauty is on the heart
~~<<Ghibran Khalil>>~~

You got to parse through the string to see if there are consecutive spaces within the string and eliminate/trim that to single space and then pass it on to LIKE operator.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Vijay:

I can´t reply in my topic "simple question about database" probably there is a problem with the page code. Anyway I just wanted to thank you for the help you gave with my problem, it worked great!!!

Thanks a lot, sorry for the delay!!!!

Liliana Meneses