>Yes, you are correct. I was installing SQL Server 2008 so I couldn't look at the help just then. They must have ripped it off from VFP. :)
>
>Thanks!
>
>>>Is there a similar function in T-SQL as the VFP RIGHT(), or LEFT() functions?
>
>>I think there are RIGHT() and LEFT() functions in SQL Server.

I was installing SQL Server 2008 Express yesterday too. Took me almost whole day to install all prerequisites.