String search problem 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. how to form the query?, if any one have sample pls send me. thanks mahe

[Niladri_Biswas]

Let me know if u r not looking for this -

declare @t table(record varchar(100))
insert into @t
select 'Hello-World' union all
select 'code - project codes are good' union all
select 'hello' union all
select ' world' union all
select ' how are u-?'

Query

select * from @t where record like '%[-]%'

Output:

record
Hello-World
code - project codes are good
how are u-?

:)

Niladri Biswas

modified on Tuesday, December 1, 2009 8:12 AM

[hvgyufg28fh38tyr78hf]

thanks 4 ur reply its like same but i am searching the hyphenated string in text file. if u know any SQL query to searchin the string in any file pls let me know. thanks mahe

[The Man from U N C L E]

How are your searching? Using Like, or some varieant of FullText searching?

If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles]  [My Website]

[hvgyufg28fh38tyr78hf]

i am searchin with CONTAINS keyword.