Hai All, I am doing following search in SQL Server2005, select * from table_1 where contains (text1,'"roll-over"') Results: 1 roll 2 notify us theday you roll check . 3 notify us the day you check roll-over. 4 notify us the day you check roll over. Could Some one tell me , is this results are right for this search?, i feel its wrong it should only return the line which is having roll-over ( 3 notify us the day you check roll-over.) how can i use this query or modified this querey to get proper results? thanks Mahe

text is not in memory ..its in original text file only.

hi all, i want to write the content of a text file to another txt file exactly like what i have in original file. i used write,writeline and put functions. but to my surprise, i found the text file is benig written without the new line character. for example: original file content: aefaiojefioae fafajfpfjafaffjaeiofjafjfjfi faijfoijf faioj Para 2: fafaopfopfkaokfopfaopkfopkopafopkfpoaf. fijaoijij fafijoifjfiajparwto MY COPIED FILE content: aefaiojefioae fafajfpfjafaffjaeiofjafjfjfi faijfoij ffaioj Para 2: afaopfopfkaokfopfaopkfopkopafopkfpoaf. ijaoijij fafijoifjfiajparwto Can anyone help me on how to write the content of the file exactly as what i have in original? Thanks, mahi.

hai what is the escape character for hyphen(-) in SQL? thanks mahe

thanks for ur reply its working fine. but is there any way to form query with CONTAINS key word. mahe

hai all i am facing some problem in SQL.I am searching the one string(ex.roll-over) in table its returning wrong results. my table contains, dable datas table_1 is table name number1 text1 1 notify us the day you roll check over. 2 notify us theday you roll check . 3 notify us the day you roll check roll-over. 4 notify us the day you roll check roll over. my query is select * from table_1 WHERE CONTAINS(text1, '"roll-over"') select * from table_1 WHERE CONTAINS(text1, 'roll-over') in both case i am getting below results. results number1 text1 1 notify us the day you roll check over. 2 notify us theday you roll check . 3 notify us the day you roll check roll-over. 4 notify us the day you roll check roll over. here it should return only one result insted of four. is there any thing wrong in Query if not can any one help to from the correct query. i think Bcoz os hyphen the result is returinig either roll or over presents. thanks mahe

thanks if u have any idea pls let me know.

i am searchin with CONTAINS keyword.

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

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

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

Hai all, i am using leadtool13 in my application ,and i am facing some problem in that,i have loaded five image in image viewer . i started to draw markups in first image ,without relesing left mouse button(without completing markups on that page) i am going into next page by pressing shotcut keys(like page down key) then my application is crasing. can anyone tell me where that problem would be. Anyone who used the leadtool can u please check this Scenario and let me know pls. how can i solve this crasing issue. thanks in advance. mahe

Hi David, thankyou for ur responce, it helped for me.i solved that problem with some other methods. thanks Mahe

Hai All, I Want to know that, will CryptEncrypt(..) and CryptDecrypt(..) Windows API's support to Encrypt and decrypt the Unicode data ? Bcoz i Did encryption and Decryption of unicode data with this API's i got Some additional Letters at the end of line. please some tell how to solve this issue. Thanks in Advance Mahe

Hi all, I am using a CryptEncrypt(..) and CryptDecrypt(..) API's to Encrypt and Decrypt XML data with unicode datas. i am facing problem in decryption.i am sending proper data for encryption but when i decrypt those datas i am getting some extra characters at the end of line like (||||..,...,etc ., its a UTF-8 letters i am getting ) Can u pls tell me what is the problem and how can i overcome from this issue. Thanks & regards Mahe