sql server 2000 i'm looking for a function that returns 2

[tempo1]

a number showing the position of a certain character.
Hi everyone,
In my select query i want to display the position of the character '-'.
My query goes like:

select position(phone,'-')

to show where the '-' of
each phone number i situated.
can anyone tell me what i should replace

position

with ?
Thanks a lot

 

[ca8msm]

Try the CHARINDEX function


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[Otto]

select charindex('e', 'abcdefgh')

But, you should open a book or the BOL before ask a trivial question like this... RTFM, said another .

 

[tempo1]

Thanks a lot !