Home Forums SQL Server 2008 SQL Server 2008 - General Get Left-most Char of Col A to insert into Col B RE: Get Left-most Char of Col A to insert into Col B
dbaforever
Hall of Fame
Points: 3740
More actions
November 14, 2012 at 8:54 pm
#1559206
Ah, I got it.
Update Table1
Set ColB = (Select Substring(ColA, 1, 1));
This worked.
Thanks.