tag:blogger.com,1999:blog-6082652835152798567.post1668749347275089033..comments2024-03-28T00:58:12.736-07:00Comments on Sql server, .net and c# video tutorial: Replicate, Space, Patindex, Replace and Stuff functions - Part 24Unknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6082652835152798567.post-64129312670746881962024-01-21T17:31:52.060-08:002024-01-21T17:31:52.060-08:00Select Email, CHARINDEX('@abc.com', Email)...Select Email, CHARINDEX('@abc.com', Email) as FirstOccurence <br />from tblEmployee<br />Where CHARINDEX('@abc.com', Email) > 0Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-18553715309797233622021-06-02T01:26:29.368-07:002021-06-02T01:26:29.368-07:00select SUBSTRING((SUBSTRING('naresh@yahoo.com&...select SUBSTRING((SUBSTRING('naresh@yahoo.com',CHARINDEX('@','naresh@yahoo.com')+ 1,len('naresh@yahoo.com') - charindex('@','naresh@yahoo.com'))),1,5)Rishabhhttps://www.blogger.com/profile/00020832259382857352noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-62677387170667292942020-12-30T23:18:56.876-08:002020-12-30T23:18:56.876-08:00in the mail for example naresh@yahoo.com
here we k...in the mail for example naresh@yahoo.com<br />here we know how to get after that "@" result is yahoo.com<br /> i want to know about i need only "yahoo" remove "com" how it is? Anonymoushttps://www.blogger.com/profile/00486427705196338264noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-6439168320767903882019-07-14T20:06:08.981-07:002019-07-14T20:06:08.981-07:00You have to use Mid functionYou have to use Mid functionAnonymoushttps://www.blogger.com/profile/06659441352173940051noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-59178760771913312312017-06-19T07:23:52.787-07:002017-06-19T07:23:52.787-07:00Hello,
I have used SUBSTRING query in MS access (...Hello,<br /><br />I have used SUBSTRING query in MS access (where we can write SQL query in MS access) but it was not executed. i dont have SQL server.<br /><br />Please help me on this.<br /><br />Thanks<br />ShyamAnonymoushttps://www.blogger.com/profile/09620721107492651024noreply@blogger.com