Всем привет, не подскажите кто знает в SQL есть аналог функции FIND??

А что ты хочешь найти?

неужели select?

символ в строке

(0) SELECT в основном...

Searches expression2 for expression1 and returns its starting position if found. The search starts at start_location.

Transact-SQL Syntax Conventions

 Syntax

CHARINDEX ( expression1 ,expression2 [ , start_location ] )
 Arguments
expression1
Is a character expression that contains the sequence to be found. expression1 is limited to 8000 characters.

expression2
Is a character expression to be searched.

start_location
Is an integer or bigint expression at which the search starts. If start_location is not specified, is a negative number, or is 0, the search starts at the beginning of expression2.

 Return Types
bigint if expression2 is of the varchar(max), nvarchar(max) or varbinary(max) data types; otherwise, int.

like?

ВЫБОР КОГДА Поле ПОДОБНО %&Символ% ТОГДА &Символ ИНАЧЕ "" КОНЕЦ как переводится на SQL?

(7)
select
 where Field LIKE '%Char%' Then 'Char'
 Else ''
End

GETWORDCOUNT() Counts the words in a string
GETWORDNUM() Returns a specified word from a string
AT() Returns the beginning numeric position of the first occurrence of a character expression within
another character expression, counting from the leftmost character
RAT() Returns the numeric position of the last (rightmost) occurrence of a character string within
another character string
OCCURS() Returns the number of times a character expression occurs within another character expression
PADL() Returns a string from an expression, padded with spaces or characters to a specified length on the left side
PADR() Returns a string from an expression, padded with spaces or characters to a specified length on the right side
PADC() Returns a string from an expression, padded with spaces or characters to a specified length on the both sides
PROPER() Returns from a character expression a string capitalized as appropriate for proper names
RCHARINDEX() Is similar to a built-in function Transact-SQL charindex but the search of which is on the right

Спасибо дяди :)