Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Search based on percentage - sql server 2005

2 Posts 2 Posters 0 Views 1 Watching

A Offline
A Offline
abcurl

wrote on last edited by

#1

I have to search keyword "searching" Out of this keyword i have to find any 8 characters in the following string "string to search" . Can u suggest any approach ?
S 1 Reply Last reply

0
A abcurl

I have to search keyword "searching" Out of this keyword i have to find any 8 characters in the following string "string to search" . Can u suggest any approach ?
S Offline
S Offline
Simon_Whale

wrote on last edited by

#2

look at the patindex function.

Marc Clifton wrote:

That has nothing to do with VB. - Oh crap. I just defended VB!
1 Reply Last reply

0

Log in to reply