How to use Like or Instr function in sql 2000?

Question

I have got text filed with data 'Bombay, Madrass, Delhi'
I want to fetch records of Madrass how can i fetch in sql 2000
plz help me.

Answer 1

select * from table where field like '%madrass%'
GO

Answer 2

You can use instring after pulling the data to see if a string exits I commonly use it with an array It returns 0 if the string is not found so if the string is there it will be the same as True if 0 is not returned. I use this in a looping structure wtih the array as below

if instr(strSearced, strSearch, -1, 1, CompareMethod.Text) <> 0

Dim i as Integer
i=0
for i=0 to ubouound(arrSome)
if instr(arrSome(i,0), strSearch, -1, 1, CompareMethod.Text) <> 0 Then

Some Action

End If

Next

Answer 3

Like:

SELECT [CITY] FROM CUSTOMERINFO WHERE CITY LIKE '%Bombay%'

There is no instr by default there is a Substr function that returns parts of strings. with that you can iterate through the text and create a UDF that does INSTR for you.

Answer 4

SELECT * FROM table_name_here WHERE city_field_name='Madrass'

Answer 5

that's appearing a validation verify on the contents of column digital mail. subsequently it exams 2 issues: instr(digital mail, '@') = instr(digital mail, '@', -a million) // famous the 1st occurrence of '@' in digital mail and exams that it replaced into the only occurrence of it by utilising commencing on the tip and finding backwards instr(digital mail, '@') between 2 and length (digital mail) // verifies that '@' happens in digital mail and that it somewhat is a minimum of the 2d character contained in the sphere (if it wasn't got here upon in any respect, the instr functionality could return 0)

Answer 6

You may use the access query tool "Advanced Access Builder" at http://www.download5000.com/page25449.aspx or http://www.dlkj.net/sqlBuilder , it allows you to visually build complete SQL scripts.

Answer 7

use charindex function

SELECT * FROM CUSTOMER WHERE CHARINDEX(ADDRESS,'MUMBAI') > 0

it will work like InStr in VB