How do I remove the last character in a string? 1

[dv8er88]

I am looping and biulding a var seperated by commas. But i need to remove the last comma.

Thanks

 

[r937]

left(string,length(string)-1)

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[r937]

ooops, my bad

left(string,len(string)-1)

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[dv8er88]

Thanks that works great.

I assume the (string) determins the length of the current var in the loop and the trims 1 char.