if I have a variable VARCHAR2(18 BYTE) and occasionally the string has empty space(ie, 'W12345678901 ' ) and after setting it to a variable, I use the variable equal to a field from a table in a query. Will it equal the string with the empty spaces? I am noticing in certain situations that it isn't? Don't have specifics but can come up with some if needed. Just wanted a little insight to how this works exactly?
I have since used TRIM on my setting of the variable. I was using TRIM in the query but I think its taking longer especially when looping through a big record set.