I want to select first 1000 characters from a column. which function should I use. (LEFT function or ltrim, rtrim): select LEFT (col_name, 1000) from table_name; select LEFT (col_name, LEN(col_name)-(no_of_char_to_trim)) from table_name;