User Profile

Collapse

Profile Sidebar

Collapse
Geko747
Geko747
Last Activity: Feb 28 '18, 10:11 AM
Joined: Feb 23 '18
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Geko747
    replied to How do I wildcard a parameter search
    in SQL Server
    I have tried but just adding a % either side does not do anything. Could you show me an example in the code of where it would go. The query works fine it will find an exact match that i type into the parameter, but i need it to be a wildcard search as i am trying to find discrepancies in our data/
    See more | Go to post

      Leave a comment:

    • Geko747
      replied to How do I wildcard a parameter search
      in SQL Server
      How would i include it within this though would it just be @invoiceaddress name%
      See more | Go to post

        Leave a comment:

      • Geko747
        started a topic How do I wildcard a parameter search
        in SQL Server

        How do I wildcard a parameter search

        Very new to all of this, I have a simple search that shows all invoice information for a client. I need to be able to search for part of the client name rather than an exact match. In Access i know a * will wildcard a search. How do I do it in SQL here is the code

        SELECT
        dimOrganisation .Name
        ,dimInstruction s.FILENO
        ,rpt_CIAReports _RawData.Invoic eID
        ,rpt_CIAReports _RawData.Alloca tionValue
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...