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 |
|
peace
Constraint Violating Yak Guru
420 Posts |
 Posted - 2012-07-27 : 05:06:40
|
| Hi,Suppose to have data something like this :{8273HU92-IP39-79YE-B319-8HBN1K883641}I already declare as nvarchar(100).How can I solve this issue?The real data suppose to be like this:HELLO-6546436-POLIS |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-27 : 06:02:34
|
How can I solve this issue?First step is to tell us what is the issue. 
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-27 : 10:23:58
|
quote:
Originally posted by peace
Hi,Suppose to have data something like this :{8273HU92-IP39-79YE-B319-8HBN1K883641}I already declare as nvarchar(100).How can I solve this issue?The real data suppose to be like this:HELLO-6546436-POLIS
give us some contexthow are you generating guid value?whats your rule for generating result string based on it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
nvarchar