Hi Neil. Thank you for your question. It's exactly the same way. The final formula would be SELECT CHARINDEX('e', 'Hello there', 1+CHARINDEX('e', 'Hello there',1 + CHARINDEX('e', 'Hello there'))) . Phillip
Hi Anshul. Thank you for your question. This happens with functions - if you type SELECT CONVERT( , then as soon as you type ( you should see the syntax for the function CONVERT. However, you won't see it for SELECT - the syntax is too complex to be shown in such an environment. See learn.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql for its syntax. Phillip
In future most will realise how powerful this lesson was and come back to like and comment. Nice one Sir.
Thanks man you're a legend!!!!!!!
Hello. From 1m40s you talk about how to find the 2nd 'e'. How would we find the third 'e' ?
Hi Neil. Thank you for your question. It's exactly the same way. The final formula would be SELECT CHARINDEX('e', 'Hello there', 1+CHARINDEX('e', 'Hello there',1 + CHARINDEX('e', 'Hello there'))) . Phillip
Nice sir..
Thank you so much
*muda muda muda muda muda muda muda muda!*
Nice..
How to enable viewing syntax and command definition [while typing any command] in MS-SQL as we see in Excel
Hi Anshul. Thank you for your question. This happens with functions - if you type SELECT CONVERT( , then as soon as you type ( you should see the syntax for the function CONVERT. However, you won't see it for SELECT - the syntax is too complex to be shown in such an environment. See learn.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql for its syntax. Phillip