Last post Jul 19, 2018 12:25 AM by oned_gk
Member
289 Points
664 Posts
Jul 17, 2018 10:18 AM|Gopi.MCA|LINK
Hello
This is my table data
I need sql query
sometime user pass S12-18 then i want to show resultset mango
sometime user pass S12A-18 then also i want to show resultset mango
sometime user pass S12B-18 then also i want to show resultset mango
sometime user pass S12C-18 then also i want to show resultset mango
how would be my where cluase code..
Need help
Thanking You
Star
8119 Points
2778 Posts
Jul 17, 2018 10:31 AM|vahid bakkhi|LINK
hi
what is your mean exactly? do you need a query that returns Batch No that include 's12' ?
Participant
1644 Points
792 Posts
Jul 17, 2018 10:36 AM|rajesh93180|LINK
Hi Gopi,
You can do like this,
SELECT * FROM <TABLE> WHERE BatchNo like 'S12%'
Jul 17, 2018 10:49 AM|Gopi.MCA|LINK
at any input i want to show mango record..
Jul 17, 2018 11:04 AM|vahid bakkhi|LINK
you can try below query in sql
declare @userSearch as nvarchar(50) set @userSearch = 'S12A-18' select * from myTable where BatchNo like '%'+SUBSTRING(@userSearch, 1, 3)+'%'
or
select * from myTable where BatchNo like '%'+SUBSTRING('S12A-18', 1, 3)+'%'
All-Star
123252 Points
10024 Posts
Moderator
Jul 17, 2018 01:37 PM|limno|LINK
CREATE TABLE mytable( Batch_No VARCHAR(6) NOT NULL ,ItemName VARCHAR(6) NOT NULL ); INSERT INTO mytable(Batch_No,ItemName) VALUES ('S12-18','Mango') ,('S13-18','Lemon') ,('S14','Dates') ,('S15','Banana'); declare @p varchar(10)='S12B-18' Select @p = Left(@p,3)+right(@p,3) Select * from mytable WHERE Batch_No=@p drop table mytable
52513 Points
15668 Posts
Jul 19, 2018 12:25 AM|oned_gk|LINK
SELECT * FROM YOURTABLE WHERE LEFT([batch no],3)=LEFT(@parameter,3)
Member
289 Points
664 Posts
Filter Data Base On Input SQL
Jul 17, 2018 10:18 AM|Gopi.MCA|LINK
Hello
This is my table data
I need sql query
sometime user pass S12-18 then i want to show resultset mango
sometime user pass S12A-18 then also i want to show resultset mango
sometime user pass S12B-18 then also i want to show resultset mango
sometime user pass S12C-18 then also i want to show resultset mango
how would be my where cluase code..
Need help
Thanking You
Star
8119 Points
2778 Posts
Re: Filter Data Base On Input SQL
Jul 17, 2018 10:31 AM|vahid bakkhi|LINK
hi
what is your mean exactly? do you need a query that returns Batch No that include 's12' ?
Please MARK AS ANSWER if suggestion helps.
Participant
1644 Points
792 Posts
Re: Filter Data Base On Input SQL
Jul 17, 2018 10:36 AM|rajesh93180|LINK
Hi Gopi,
You can do like this,
Mark as answer if you find this post helpful.
Member
289 Points
664 Posts
Re: Filter Data Base On Input SQL
Jul 17, 2018 10:49 AM|Gopi.MCA|LINK
Hello
I need sql query
sometime user pass S12-18 then i want to show resultset mango
sometime user pass S12A-18 then also i want to show resultset mango
sometime user pass S12B-18 then also i want to show resultset mango
sometime user pass S12C-18 then also i want to show resultset mango
at any input i want to show mango record..
Star
8119 Points
2778 Posts
Re: Filter Data Base On Input SQL
Jul 17, 2018 11:04 AM|vahid bakkhi|LINK
you can try below query in sql
or
Please MARK AS ANSWER if suggestion helps.
All-Star
123252 Points
10024 Posts
Moderator
Re: Filter Data Base On Input SQL
Jul 17, 2018 01:37 PM|limno|LINK
Format your SQL query with instant sql formatter:
http://www.dpriver.com/pp/sqlformat.htm
All-Star
52513 Points
15668 Posts
Re: Filter Data Base On Input SQL
Jul 19, 2018 12:25 AM|oned_gk|LINK
Suwandi - Non Graduate Programmer