converting Access command line to SQL 1

[smuthcrmnl777]

In MS Access, I can create this command line.

Right([Product name],InStr([Product name],',')+3)

Is there a way to reproduce this in SQL?

 

[bborissov]

RIGHT([Product name],CHARINDEX(';',[Product name])+3)

(not tested)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[smuthcrmnl777]

I also have to do this...


Right([Product name],InStr([Product name],'COM')+3)


How do I go about doing this?

 

[bborissov]

The same.
CHARINDEX:
Returns the starting position of the specified expression in a character string.

RIGHT([Product name],CHARINDEX('COM',[Product name])+3)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[smuthcrmnl777]

cool thanks!!!!