Posted by Hugo Kornelis on 09/30/86 11:16

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)

• Next in forum: Re: Using EXISTS
• Prev in forum: Re: IF...ELSE error
• Thread view: Re: Newbie question on SQL Query writing

[Reply to this message]