Newbie question on SQL Query writing

Hi,

I am new to writing SQL queries in MS SQL & would like to do the
following: Write a query to retrieve all strings that start with a
particular value.

Basically, I am looking for the SQL equivalent of the regex "^".

Thanks,
AshokSELECT column1 FROM mytable WHERE charindex('Search Text', column1) = 1|||On 18 May 2005 08:01:46 -0700, ashok.anbalan@.gmail.com wrote:

>Hi,
>I am new to writing SQL queries in MS SQL & would like to do the
>following: Write a query to retrieve all strings that start with a
>particular value.
>Basically, I am looking for the SQL equivalent of the regex "^".
>Thanks,
>Ashok

Hi Ashok,

Assuming they need to start with 'a':

SELECT Column list
FROM MyTable
WHERE TheStringColumn LIKE 'a%'

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

Newbie Needs Help

I have experience with MS Access, but I am an absolute newbie when it
comes to MySQL. I was looking over the site, mysql.com and found the
following downloads:

MySQL Database Server
Generally Available (GA) 4.1.10
Alpha 5.0.2
Documentation

MaxDB by MySQL
Generally Available (GA) 7.5.00
Beta 7.6.00
Documentation

MySQL Administrator
Generally Available (GA) 1.0.19
Documentation

What are the differences between MySQL Database Server, MaxDB by MySQL,
and MySQL Administrator?

Also, I plan to load this on a Windows XP machine. Is there anything
that I should keep in miind when I do this?

Thanks in Advance,
TammyThis is a Microsoft SQL Server group so you'll probably want to refer
instead to a MySQL resource: http://dev.mysql.com/support/

--
David Portas
SQL Server MVP
--