SQL Stored Procedure to find Person Name over FullText Table
Budget: $10 – $30 USD
I need the SP code for Microsoft SQL that receives as a parameter a string composed by 2, 3 or 4 words (First Name/s, Midle Name and Last Name/s, in any order) and Query a Full-Text indexed Table to search on it.
PERSON = "Word1 Word2"
PERSON = "Word1 Word2 Word3"
PERSON = "Word1 Word2 Word3 Word4"
PERSON = "Word3 Word1 Word2" or any combination (distance 1 or 2)
PERSON = "Word1 Word2"
PERSON = "Word1 Word2 Word3"
PERSON = "Word1 Word2 Word3 Word4"
PERSON = "Word3 Word1 Word2" or any combination (distance 1 or 2)