select *

from quer a

cross join (select 'Text1' as MyText union all select 'Text2') x

select *

from quer a

cross join (select 'Text1' as MyText union all select 'Text2') x

select *

from quer a

cross apply (values('Text1'), ('Text2')) x (MyText)

jodevil99 (8/13/2015)

---

Well, considering the error messages did not say much more and were in french, I don't think it was really relevent to post a french error message here

Sean Lange (8/13/2015)

---

Every table name and every column name are exactly 6 UPPER case letters.

Ed Wagner (8/13/2015)

---

I've worked in both environments and really prefer case-insensitive. As a habit, though, I try to write everything as case-sensitive.

Ed Wagner (8/13/2015)

---

I've worked in both environments and really prefer case-insensitive. As a habit, though, I try to write everything as case-sensitive.

Sean Lange (8/13/2015)

---

Every table name and every column name are exactly 6 UPPER case letters.

...Of course the case sensitivity thing is rather silly in that system. Every table name and every column name are exactly 6 UPPER case letters.

Ed Wagner (8/11/2015)

---

It is good to hear that Baan is no more, but I'm not surprised. I guess their miserable product finally caught up with them.

anjaliagarwal5 (8/12/2015)

---

there are lot of values inserting in that table, but this special character will be always at the end if present.