I have a column whose values range from 10-15 characters and whose last 7 characters I would like to get rid of. Can someone please show me how to do this? I thought it would be RTRIM but that didn’t work for me. I can’t use LEFT or RIGHT before the column because the column [...]
Answer Question | June 29, 2010 6:40 PM
RTRIM, SQL Server Express 2005, SQL Server Functions, TRIM function
I need to get cities’ name from a format like this: Los Angeles, CA New Orleans, LA etc.. I’ve tried: substr(a.air_location, -4) but that gives me the opposite…”, LA” Any suggestions? Thanks.
Answer Question | May 7, 2009 5:21 AM
InStr function, RTRIM, SUBSTR, Substring