Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 476
  • Last Modified:

Find the space character in a string

How can I find the space character in a string ?
I tried this statement, but I always get 0 regadles of the value of myfield:
Select CHARINDEX(myfield,' ')
From mytable

Thanks,
0
marper
Asked:
marper
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Select CHARINDEX(' ', myfield)
From mytable
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now