Jul 28, 2020 4:01 am
Is there a way to achieve this?
1 Reply
Jul 29, 2020 3:35 pm
You can use three methods to acheive this.
Using Method 1 Select * from Students where CHARINDEX('S',Name)=1
Using Method 2 Select * from Students where LEFT(Name,1)='S'
Using Method 3 Select * from Students Where SUBSTRING(Name,1,1)='S' ( First 1 is Number of Char and Second 1 is position)
Is this useful?
Leave a reply
Forum Statistics
10
Forums
174
Topics
321
Posts
0
Online
1,386
Members
Latest Post: Query Optimization: A Comprehensive Guide for Stored Procedures Our newest member: anjalirrb Recent Posts Unread Posts
