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 |
|
Krefit
Starting Member
1 Post |
 Posted - 2014-12-09 : 17:34:06
|
Hello everybody!
I'm having some troubles with a dynamic field of mine db. The field can change in the lenght. But I nee to change the way it come from the db.
Today it comes like this:
Cod OU | Name OU
10000 Alabama
10100 Olivence
10001 Wraith
I need to change the Cod to be like this:
Cod OU* | Name OU
1.00.00 Alabama
1.01.00 Olivence
1.00.01 Wraith
Is it possible? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-09 : 17:42:00
|
Is it always 5 digits? Is it varchar or char data type (and length)?
Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Dynamic Field