I have a fields with the space char in data.
How to find a space character in query?
'Smith David'

You can look for a space with Char(32).
One way is to return the position of the space with
CHARINDEX...e.g. in pubs database you could do something
like:
SELECT pub_name, CHARINDEX(Char(32), pub_name)
FROM publishers

-Sue

On Wed, 26 Jan 2005 08:12:29 -0800, "anonymous"
<anonymous (AT) discussions (DOT) microsoft.com> wrote: