Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-08-31 : 08:43:14
|
| Hi iam having one table let us say x having column z as datatype varcharwhen ever iam inserting value as '\r\n\tHyperthyroidism - 'it shoud give me like Hyperthyroidism - onlu bit it is giving like \tHyperthyroidism -ca you please help me out |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-08-31 : 08:48:08
|
| How are you retreiving the data?MadhivananFailing to plan is Planning to fail |
 |
|
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2009-08-31 : 08:53:18
|
| automatically value is inserting exactly what the above mentioned ones.bit i dont want like that. |
|
|
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2009-08-31 : 09:01:32
|
| insert into a(name) values ('\r\n\tHyperthyroidism - ')select * from a;\r\n\tHyperthyroidism - i want like Hyperthyroidism - |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-08-31 : 09:04:34
|
| select right('\r\n\tHyperthyroidism - ',charindex('\', reverse('\r\n\tHyperthyroidism - '),0)-2) |
|
|
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2009-08-31 : 09:13:04
|
| how to give insert then |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-08-31 : 09:29:32
|
quote:
Originally posted by rajasekhar857
how to give insert then
How are you sending data to table?Are you using front end application?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
\t giving problem