TID BADGEID NAME Location Addr 122 233.01 Katy GA GA-54 123 234.02 tery GA GA-54
I want to insert 0 after. like below
TID BADGEID NAME Location Addr 122 233.001 Katy GA GA-54 123 234.002 tery GA GA-54
I have this solution in my mind not sure it's correct. worried if it's going to mess my data:
update studentinfo set BADGEID = '.###' where location = 'GA'