Hi, <BR>I'm trying to select the first 4 letters in the city name of a record. For instance, the Column heading is city, the record is Austin and I want to return Aust. Anyone know how to do this?<BR><BR>Thanks!
select left(ColumnName, 4) ColumnName from....<BR><BR><BR>
Might be worth doing a Ltrim too you never know<BR><BR>Left(Ltrim(columnname), 4)
thank you thank you everyone!!!!
Try the ltrim function