Well sure, but that depends on the data cleanliness... The hope is the OP understands his data, he didn't mention any problems with rogue spaces. On that topic, you can use TRIM to cull not only spaces, but any kind of unwanteds, I usually have this in unclean data: ``` TRIM(someCol, CHAR(9)|CHAR(10)|CHAR(13)|CHAR(32)|CHAR(160)) ``` That Char 160 (0xA0) can especially be tricky, just cause it walks like a space and talks like a space, doesn't mean it definitely is a space. There are more Unicode "space" characters too in case your data is of the international unicode-containing ilk. Link: http://jkorpela.fi/chars/spaces.html (It's not an https:// link so did not want to embed it in the markdown.)