Let's assume i have table of my clients: \[code\]firstName,MiddleName,LastName\[/code\]. I want to select all the records where LastName equals to or is near the same as 'Robert'. By near the same I mean that maximum of 25% of characters in entered text differ from the some value in DB. Is it possible to achieve that in Microsoft SQL sver 2008? Why do I need this? Let's say user entered 'peterdson' instead of 'peterson'. I want to display user message that suggests the more relevant result.
Select all records where value is near the same
- Thread starter Keltic
- Start date