Filter Data Base On Input SQL[Answered] RSS

• • Reply
  Gopi.MCA

  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

  Batch No	ItemName
  S12-18	Mango
  S13-18	Lemon
  S14	Dates
  S15	Banana

  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

• • Reply
  vahid bakkhi

  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' ?

   

  vahid bakhtiary
  
  Please MARK AS ANSWER if suggestion helps.
• • Reply
  rajesh93180

  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,

  SELECT * FROM <TABLE> WHERE BatchNo like 'S12%'

  -Rajesh Vemunoori LinkedIn Profile
  
  Mark as answer if you find this post helpful.
• • Reply
  Gopi.MCA

  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..

• • Reply
  vahid bakkhi

  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

  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)+'%'

  vahid bakhtiary
  
  Please MARK AS ANSWER if suggestion helps.
• • Reply
  limno

  All-Star

  123252 Points

  10024 Posts

  Moderator

  Re: Filter Data Base On Input SQL

  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

  Jingyang Li
  Format your SQL query with instant sql formatter:
  http://www.dpriver.com/pp/sqlformat.htm
• • Reply
  oned_gk

  All-Star

  52513 Points

  15668 Posts

  Re: Filter Data Base On Input SQL

  Jul 19, 2018 12:25 AM|oned_gk|LINK

  SELECT * FROM YOURTABLE WHERE LEFT([batch no],3)=LEFT(@parameter,3)

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer