How do I right justify a string in an insert query

rakesh17684 · New User Joined: 08 Oct 2006 Posts: 61 Location: San Diego

Hi,

I want to insert large number of rows with one of fields going into a column defined with CHAR 30. I need the string inserted into the column to be right justified. How can it be done in an insert query ?

Thanks
Rakesh

Rohit Umarjikar · Posted: Wed Jun 08, 2016 8:24 pm

Why do you care how the data is stored in database? You need something on SELECT query to see it right justified only for YOU because then if someone don't want that way (now or in future) apart from you who uses that table then they will have to add additional function all the time when they references this field.
Try this.