problem in hyphen character in string search in SQL server

hvgyufg28fh38tyr78hf

Hai all, I am searching one string (ex.Hello-Welcome) in text file using SQL query. its searching Hello and Welcome seperatly and giving a result , i think bcoz hyphen(-) is a word breaker in SQL .can any one give me the idea how to resolve the problem. i need to use hyphen in searching string, and i need a combined string search result. thanks mahe

Lost User

This does not appear to be a C++ question. You may get better visibility by posting in the General Database forum.

hvgyufg28fh38tyr78hf

thanks if u have any idea pls let me know.

CPallini

You may escape the hyphen, see, for instance [^] (have a look at example "C. Using the ESCAPE clause"). :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]