468,242 Members | 1,466 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.


374 256MB
i have 4000 rows in a column that has numeric values such as 12345678 in each of them
how would i change the values to have a comma in it such as 123,45678 ???

I need to change all of them.

Please help
Nov 26 '08 #1
2 1033
If the comma always goes in the same place could you use:

Expand|Select|Wrap|Line Numbers
  1. UPDATE    Table
  2. SET        Column = substring(Column,1,3) + ',' + substring(Column,4,200)
Nov 26 '08 #2
2,878 Expert 2GB
if this is for display purposes, you might as well handle that on your front-end, much easier, less stress to the server.

-- CK
Nov 26 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

27 posts views Thread by Alberto Vera | last post: by
5 posts views Thread by Derek | last post: by
2 posts views Thread by benben | last post: by
11 posts views Thread by Shawn Odekirk | last post: by
4 posts views Thread by G Patel | last post: by
21 posts views Thread by siliconwafer | last post: by
9 posts views Thread by Wayne | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.