[SQL] Trailing spaces - is there an easier way?

I'm sure this has been asked before, but I couldn't find it: I have a "zzz CHAR (8)" field. It needs to be CHAR because trailing spaces need to be ignored for most operations. However, I need to concatenate it with another (literal) string and need the spaces to be significant in that operat

Re: [SQL] Trailing spaces - is there an easier way?

2010/11/4 Dean Gibson (DB Administrator) : > I'm sure this has been asked before, but I couldn't find it: > > I have a "zzz CHAR (8)" field.  It needs to be CHAR because trailing spaces > need to be ignored for most operations.  However, I need to concatenate it > with another (literal) string and

Re: [SQL] Trailing spaces - is there an easier way?

On Thu, Nov 04, 2010 at 08:42:21PM +0100, Pavel Stehule wrote: > 2010/11/4 Dean Gibson (DB Administrator) : > > I'm sure this has been asked before, but I couldn't find it: > > > > I have a "zzz CHAR (8)" field.?? It needs to be CHAR because trailing spaces > > need to be ignored for most operation

Re: [SQL] I'm stuck - I just can't get this small FUNCT to run!

Thank you both. I stared and stared and stared, and apparently I needed to take a walk around the building I have repeatedly asked about an upgrade, but as you mentioned Tom, it's a compatibility issue and concern that remote programmers might end out making more work for themselves. <> If I