Tag Archives: SQL Command Concat

TRIM: TRIM()- TRIM function in SQL is used to remove specified prefix or suffix from a string. LTRIM(str): Removes all white spaces from the beginning of the string. SELECT LTRIM(‘   Sample   ‘); RTRIM(str): Removes all white spaces at the end of the string. SELECT RTRIM(‘   Sample   ‘); CONCAT*Sometimes it is necessary to combine together (concatenate) the results from severalContinue reading “SQL Command – CONCAT, TRIM, Like”