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 |
|
ppatel112
Starting Member
35 Posts |
 Posted - 2015-03-05 : 19:39:02
|
| Hi Peeps,i have a column in sql table where it consists of a card number for e.g. 5555444433332222i want to write a select statement with the column name with card number above for me to export to csv.the format needs to be like 5555-4444-3333-2222How can we achieve this?thanks,parth |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-05 : 19:54:02
|
| You can use the SUBSTRING function for this.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
adding a space or a character after 4 digits