Database

DECLARE @Table AS Table(
    ID Int,
    [Name] nVarChar(50))
    
INSERT @Table(ID, Name)
  VALUES(1, '"The less you talk..."') 
INSERT INTO @Table
  SELECT 2, 'The long and...'
INSERT INTO @Table
  SELECT 3, '-ABC of Math'
INSERT INTO @Table
  SELECT 4, '*Something Else'


          
SELECT * FROM @Table
ORDER BY (SELECT CASE WHEN (UNICODE(SUBSTRING(Name,1,1))< 123)
                      THEN UNICODE(SUBSTRING(Name, 2,1))
                      ELSE Name End) ASC

ID      Name
-----------------------------
3	-ABC of Math
4	*Something Else
1	"The less you talk..."
2	The long and...

DECLARE @Table AS Table(
    ID Int,
    [Name] nVarChar(50))
    
INSERT @Table(ID, Name)
  VALUES(1, '"The less you talk..."') 
INSERT INTO @Table
  SELECT 2, 'The long and...'
INSERT INTO @Table
  SELECT 3, '-ABC of Math'
INSERT INTO @Table
  SELECT 4, '*Something Else'
INSERT INTO @Table
  SELECT 4, '? A Question'
INSERT INTO @Table
  SELECT 4, '#Regions'
INSERT INTO @Table
  SELECT 4, 'Sometimes you are right.'
INSERT INTO @Table
  SELECT 4, 'Little creatures'

          
SELECT * FROM @Table
ORDER BY (SELECT CASE WHEN (UNICODE(SUBSTRING(Name,1,1))< 123)
                      THEN UNICODE(SUBSTRING(Name, 2,1)) 
                      ELSE Name  End
              ) ASC

ID	Name
-------------------------------
4	? A Question
3	-ABC of Math
4	#Regions
4	*Something Else
1	"The less you talk..."
2	The long and...
4	Little creatures
4	Sometimes you are right.

DECLARE @Table AS Table(    ID Int,    [Name] nVarChar(50))    
INSERT INTO @Table  SELECT 1, '"The morning..."'
INSERT INTO @Table  SELECT 2, 'The long and...'
INSERT INTO @Table  SELECT 3, '-ABC of Math'
INSERT INTO @Table  SELECT 4, '*Something Else'
          
SELECT * FROM @Table
ORDER BY (SELECT CASE WHEN (UNICODE(SUBSTRING(Name,1,1))< 123) 
                     THEN UNICODE(SUBSTRING(Name, 2,1))                      
ELSE Name End) ASC

AlexeiXX3 wrote:

Notice that the title may o may not have or may have more than 1 special character at the beggining

I are Troll

Michel Godfroid wrote:

Semi-colons do not display in Braille?

CREATE PROCEDURE  CreateOrderDetails

	(
		@ProductName			NVARCHAR(50), 
		@Price				NVARCHAR(10), 
		@Quantity			NVARCHAR(10), 
		@Total				NVARCHAR(10)
	)

AS

SET NOCOUNT ON

DECLARE @MyRecordId		INT

INSERT INTO
	TableA (productname, price, quantity, total)
VALUES
	(@ProductName, @Price, @Quantity, @Total)

--Get the ID of the record we just created
SET @MyRecordId  =  SCOPE_IDENTITY()

INSERT INTO
	TableB  (Orderid, productname, price, quantity, total)
SELECT 
	Orderid, productname, price, quantity, total
FROM
	TableA 
WHERE 
	Orderid = @MyRecordId

RETURN @@ERROR
SET NOCOUNT OFF

test-09 wrote:

Now i need to search columns from 5 tables How can i do it....