Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.7K
|
Hello I'm having a problem to calculate the sum of digits from a field. Example: 1234 I want to sum 1+2+3+4, in order to obtain the result 10. Using the following query I obtain the result, but only by mere coincidence: SELECT model, CONVERT (NUMERIC(6,0), SUBSTRING(model,1,1)*1.0+SUBSTRING(model,2,1)*1.0+SUBSTRING(model,3,1)*1.0+SUBSTRING(model,4,1)*1.0) FROM product The column …
|